| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Files cause large file sizes when saved | Excel Worksheet Functions | |||
| When saving files, I get a back up of the same file saved as well | Excel Discussion (Misc queries) | |||
| Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
| Printing from a saved print file | Excel Discussion (Misc queries) | |||
| Open file saved in HTML format | Excel Programming | |||
Hybrid Mode
