Print Spreadsheet to PDF file

V

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Images are pixelated when saving to PDF 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0
Printing to pdf 3
VBA Export to PDF 0
Print to PDF format 4
creating a macro to print PDF 5
Saving as PDF and printing in a macro 0
Creating PDF files via 995 1

Top