Print Spreadsheet to PDF file
 

Hi I am trying to send a spreadsheet to the PDF printer this code sends it to
the PDF printer but I can't open the file?, can any body help or explain to
me why.
Regards
Charles

Sub CreatePDF()
Application.ActivePrinter = "PDF1 on Ne06:"
ActiveWindow.SelectedSheets.PrintOut , PrToFileName:="test.pdf"
End Sub

Print Spreadsheet to PDF file
 

Check out the below link by Ron

http://www.rondebruin.nl/pdf.htm

If this post helps click Yes
---------------
Jacob Skaria


"vqthomf" wrote:

Hi I am trying to send a spreadsheet to the PDF printer this code sends it to
the PDF printer but I can't open the file?, can any body help or explain to
me why.
Regards
Charles

Sub CreatePDF()
Application.ActivePrinter = "PDF1 on Ne06:"
ActiveWindow.SelectedSheets.PrintOut , PrToFileName:="test.pdf"
End Sub