All,
I'm trying to automate a process in Excel VBA to send out Excel reports to external clients in PDF format. (I'm using Excel 2003 & Acrobat 9 Standard.) When I record the macro to print to PDF, I get the following.
Code:
Sub Macro3()
Application.ActivePrinter = "Adobe PDF on Ne00:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"Adobe PDF on Ne00:", Collate:=True
End Sub
This does indeed create the PDF files, but it opens Acrobat and puts the new file there with a default name (same as the Excel with a .pdf extension which is OK). I've found that if I go to File/Print and select the Printer Properties button for the Adobe PDF printer, I can manually set the path & I can deselect the "View Adobe PDF Results" checkbox. Once I've done that, I can cycle through all my Excel files to create them without opening Acrobat and having the user do anything. These two things would solve my problem.
Is there any VBA code that gets me to the Printer Properties and, if so, what are the properties names for those two options?
Thanks in advance!!!
Nate