Printing to file

[Slaz]

Using good old Microsoft Excel 2002

I have a workbook set up that has 5 pages. One of those pages is set up
just to print out an invoice. Printing works great; but I would like
also to be able to "Print to File" so that I could attach that invoice
file to a email.

 

[Michael Bednarek]

Using good old Microsoft Excel 2002

I have a workbook set up that has 5 pages. One of those pages is set up
just to print out an invoice. Printing works great; but I would like
also to be able to "Print to File" so that I could attach that invoice
file to a email.

I think you'll need one of those pseudo printer drivers which produce
PDF files when printing to them. There's a whole bunch of free and
paid-for such programs around, many based on Ghostscript. My preferred
program is PDFCreator, mainly because it can be controlled from within
VBA code via its COM interface.

 

[CellShocked]

Using good old Microsoft Excel 2002

I have a workbook set up that has 5 pages. One of those pages is set up
just to print out an invoice. Printing works great; but I would like
also to be able to "Print to File" so that I could attach that invoice
file to a email.

This will work, HOWEVER, the printer on the receive end MUST be the
same. The 'print to file' function is a function of your printer's
driver, and therefore the 'file' that it creates is specifically for that
printer or printer family only. If it works on another brand's printer
it is only because they share the same print engine, i.e. Cannon, etc.

The person on the other end passes the file to the printer using a
batch file with the string:

"Type filname.prn |PRN"
or
"type filname.prn >LPT1"

or similar. I think the type command is required.

 

[Slaz]

Downloaded PDFCreator. Works great and this is all I need or want.
Thanks for your prompt reply and help.