printing, Print file

microsoft.public.excel.printing - Microsoft Office Excel


printing >> Print file

by Rob Bovey » Tue, 29 Jun 2004 05:55:36 GMT

"Peter" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
> Does anyone know how to print from a saved excel print file?

Hi Peter,

I'm assuming you mean that you've printed an Excel worksheet to a file
and now you want to send that print file to the printer?

Let's say you've printed it to a file called MyFile.prn. You need to
physically copy the file to the computer that has the correct printer
attached (the one selected when you printed to the file). Let's say you copy
it to the C:\ folder of this computer. You then open up a command prompt
window and enter the following:

C:\> C:\MyFile.prn LPT1

where LPT1 is the port to which the printer is attached on that machine. You
can also change the path and filename to suit your circumstances.

--
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 *



Top

printing >> Print file

by UGV0ZXI » Tue, 29 Jun 2004 06:17:01 GMT


Thanks Rob, That answers my question (I have never seen this information in any documentation by the way) but is it also possible to email the print file to someone so they can print it on a printer that is not configured on the computer that generated the print file? Regards, Peter
Top

printing >> Print file

by Rob Bovey » Tue, 29 Jun 2004 06:25:46 GMT


in any documentation by the way) but is it also possible to email the print
file to someone so they can print it on a printer that is not configured on
the computer that generated the print file?

Hi Peter,

The short answer is no. The print file is a binary file that contains a
series of print commands that will only be understood by the printer that
was active when you printed to the file. Now if you have two closely related
models of printer from the same manufacturer it's quite possible it will
work, but you can't depend on it.

The general idea behind printing to a file is that you can load the
printer driver for a printer that you don't have onto your computer, print
to a file with that printer active, then take the resulting print file to a
computer that does have that printer and print it out.

--
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 *
Top
Similar Threads

1. How to actually print files created by "print to file" - Microsoft Office

2. Printing from a saved print file 

I have saved a printer output to a file - how do I now open that file to 
print it?

3. .mdi print files no longer accessible and now print in .tif - Microsoft Office

4. Print file name to all files from excel? 

Hi folks. I want to setup excel to print the file name on all the files
that I print from it.  Is there a way to do that?  Thanks.

5. Unreadable characters in file with Print #File in VBA - Excel

6. Printing Files from Earlier Versions in Excel 2007 

Files created in Excel 2007 print as expected.  Files created in Excel 2003 
look fine in the preview, but print with overlapping cells.  The only way 
around this problem seems to be to copy all the information, then paste it 
"values only" into a new spreadsheet - but of course all the formulas and 
formatting are lost.  Does anyone have a better solution.

7. Issues when trying to print file from Excel 2008 Mac to Excel 2007 - Excel

8. Printing file names on docs 

When printing, how do I include the file name on the bottom of a Word or 
Excel document?