Hello!
I have a code that is used for printing a folder full of Excel files to PDF. This code makes sure that the full Excel workbooks are printed, and it does not crash unlike Adobe's batch printing service. The only problem is I can not stop it from prompting me for the save location. When I set an output folder in my Adobe PDF printing preferences, this is ignored by Excel for some reason. When I open one of the Excel files and go to "Printer Properties" (which is the Adobe PDF printer), it always shows "Prompt for Adobe PDF filename". This is despite going to the same Printing Preferences in Windows and specifying the save location. Since my preferences are being ignored, I thought I could get around it using the VBA script.
I've tried using Application.SendKeys "~", but this doesn't appear to do anything. I am still prompted for a save location and have to press enter. This is unreasonable when I am dealing with hundreds of Excel to PDF conversions a day.
Can I specify the save location within the VBA code? I have pasted what I have already below. I'm a novice to VBA so any help is greatly appreciated. Thank you!
Bookmarks