Thread: Print Spreadsheet to PDF file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
vqthomf vqthomf is offline
external usenet poster
  
Posts: 104
Default 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

Reply With QuoteReply With Quote