Interacting with other open windows

[Afshin]

[Background] I have created a report in Access which I need to create PDF's for each individual record that feed the report (about 5,000). I have Acrobat Distiller which I can assign as the default printer. This will create a PDF file of the report when the report is sent to be printed.

[Problem] When I run my code (in a Module) to print, Distiller pops up a dialogue box asking for the path and filename to save the PDF file. Unfortunately, Distiller won't allow me to disable the dialogue box. So I have to sit there and hit the OK button 5,000 times.

[Question] I need code that can: a) detect open windows, including dialogue boxes, b)feed it an event (such as filling in the path and filename in the "save as" text box), and c) "hit" the "OK" or "submit" button.

Is this possible? Any insight will be greatly appreciated.