I am trying to get eDocPrinter PDF Pro to create a pdf file from 2 tabs in an Excel spreadsheet. I was hoping to just take Record a Macro code and use it, but currently when I run the code below it leaves me at the 'Save As' dialog box with the name of the Excel file as the pdf name and I have to click Save. The problem with this is that I would like to run through a list of data in another tab and create 40+ pdf files with unique names all at once. Is there a way to modify the filename and complete the Save action using VBA code?
Code:
Sub TestPDF()
'
' TestPDF Macro
'
Sheets(Array("Summary", "Summary 2")).Select
Sheets("Summary").Activate
ExecuteExcel4Macro _
"PRINT(1,,,1,,,,,,,,2,""eDocPrinter PDF Pro on Ne02:"",,TRUE,,FALSE)"
End Sub