I am trying to figure out a way to print a "mainframe" style report using VBA. I am attempting to open the file with Excel but it's being very problematic getting it to format and print properly and I'm wondering if anybody has any existing code or suggestions.
Details: the report I am trying to print is approximately 133 characters wide; the data is formatted into fixed-width columns; the pages are separated by Form Feed characters (ASCII code 12).
What I am looking for is a way to send this report to a printer, in landscape mode, one page wide with all 133 characters on each page, with page breaks at each Form Feed.
If anybody has suggestions other than using Excel, I am open to hearing them also.