Print Spreadsheet to PDF file

[vqthomf]

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

 

[Jacob Skaria]

Check out the below link by Ron

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

If this post helps click Yes