PrintToFile param - what's the file format?

J

jstrater

I tried using the PrintToFile parameter in the Worksheet.PrintOut method and I get files, but I can't seem to open them. Is this a weird printer format, or should I be seeing a workbook file here

Thanks

James
 
R

Rob Bovey

jstrater said:
I tried using the PrintToFile parameter in the Worksheet.PrintOut method
and I get files, but I can't seem to open them. Is this a weird printer
format, or should I be seeing a workbook file here?

Hi James,

When you print to file you get a file that is formatted in whatever
codes your printer understands. It's not meant to be human-readable. It's
generally used when you don't have a direct connection to a specific
printer. You can load the printer driver for that printer, print to file,
then stick the file on a floppy disk, take it to a machine that's connected
to that printer and send the file to the printer from the command line.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
J

jstrater

That's kind of what I figured, though I was hoping it would be something human viewable, for debugging purposes. Thanks for the info
 
D

Dave Peterson

If you install the Generic Text printer and print to that, then you'll be able
to see the results in your favorite text editor.
 
Top