Printing to Adobe without getting promt for name

D

Danny McCarthy

I am trying to print an excel spreadsheet to adobe without getting a
prompt for the filename. I am getting the runtime error '1004'
"Method 'PrintOut' of object 'sheets' failed"

Can anyone help me?

Sheets(Array("Front Sheet", "Sales", "MP")).Select
Sheets("Front Sheet").Activate
ActiveWindow.SelectedSheets.PrintOut _
Copies:=1, _
ActivePrinter:="Acrobat PDFWriter on LPT1:", _
PrintToFile:=True, _
PrToFilename:="C:\temp\Week 43.pdf"
 

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

Print to PDF using PDF-XChange 3.0 2
issues with getting .pdfs to be created 3
Vba printout 2
Printing multi-page and multi-orientation excel tab to PDF 0
Excel to PDF 2
Printing PDF outputting to multple files - change to 1 file 5
Error when printing to Acrobat 1
vba printout to pdf file 2

Top