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

G

Guest

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?
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print To pdf Not Working 6
Excel to PDF or XPS boilerplate routines 3
Addobe PDF printer 3
Automated Print from Excel to PDF 2
issues with getting .pdfs to be created 3
print 2 sheets on one paper 5
PDF document with VBA? 3
How to create a PDF document with VBA? 1

Top