What format are files saved in when printing to a file from Excel
 

I am printing output generated in Excel to a file using VBA code
[ActiveSheet.PrintOut Copies:=1, PrintToFile:=True, Collate:=True].

What format is the file printed in and how do you read the file?

What format are files saved in when printing to a file from Excel
 

It is in the language of the printer that you have selected as the default.
If a postscript printer, it will be a postscript file. This can be read
with Adobe Distiller (I believe) or any application that will accept a
postscript file (more likely found in a UNIX environment I would think).
For other printer languages, you would need to find something that can read
it although I don't think these are widely available.

If you use the generic text driver for the print driver, then it will
produce a Text file you can look at in Notepad or Wordpad with a monospaced
font.

--
Regards,
Tom Ogilvy

"RonVanNost" wrote in message
...
I am printing output generated in Excel to a file using VBA code
[ActiveSheet.PrintOut Copies:=1, PrintToFile:=True, Collate:=True].

What format is the file printed in and how do you read the file?