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

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

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

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

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