Macro to create PDF's

[zara_puppy]

I have a database that has reports that get posted to a website. The reports don't keep their format well in HTML output so I use Acrobat to create PDF's. There's a total of about 20 reports per week so it's not that big of a chore. OpenReport with the view set to print will open the save dialog box for Acrobat. Is there any way to pass a message that will "click the save button" - and then allow for the overwrite of the file to that location? Just curious - and thanks in advance.

 

[Jonathan Kok]

I don't think that's an option, however, you can set the PDF printer to not prompt for a file name. Right-click on the Adobe PDF printer in your control panel, and select 'Printing Preferences'. Uncheck the 'Prompt for PDF File Name' and 'Ask to Replace existing PDF file' checkboxes.

Of course, this will affect anything that prints to that printer, but if you're running all the reports at the same time, then make the change, print the reports, and change it back.

HTH, Jonathan