Where does the "print to file" save?

C

CBW

When you choose "print to file" where does the file save so you can retrieve
it later?
 
B

Bill Martin

When you choose "print to file" where does the file save so you can retrieve
it later?
Click to expand...

-----------------

That's a function of your printer driver, and Excel doesn't know anything
about it. On my XP-Home setup for example, if I tell Excel to print
something, and then tell the print driver to "Print to File" it pops up a
dialog box asking me to give it a file name. If I tell it to use
c:\Junk.prn then that's where it puts it.

Bill
 
D

Dave Peterson

And remember that if you print to file, you're using the printer codes for that
selected printer.

If you're using anything besides a Text printer, that file won't be useful for
much. You'll be able to issue a DOS command to copy it to that specific printer
type--but it usually won't work for other printer types.
 
C

CBW

Great, that's what I needed to know, I wasn't sure about giving it the .prn
extension, I thought it was automatic.
 
Top