ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Where does the "print to file" save? (https://www.excelbanter.com/excel-discussion-misc-queries/76303-where-does-print-file-save.html)

CBW

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

Bill Martin

Where does the "print to file" save?
 
On Thu, 9 Mar 2006 11:41:40 -0800, CBW wrote:

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


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

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

Dave Peterson

Where does the "print to file" save?
 
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.



CBW wrote:

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


--

Dave Peterson

CBW

Where does the "print to file" save?
 
Great, that's what I needed to know, I wasn't sure about giving it the .prn
extension, I thought it was automatic.

"Bill Martin" wrote:

On Thu, 9 Mar 2006 11:41:40 -0800, CBW wrote:

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


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

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


CBW

Where does the "print to file" save?
 
Thanks, I has forgotten that it is a specific file. Great job!

"Dave Peterson" wrote:

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.



CBW wrote:

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


--

Dave Peterson



All times are GMT +1. The time now is 01:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com