Automatically Running a macro that exports a file

[Reuser]

Hi all, so I have a macro that generates a report from the access database, and exports it as a pdf. I would like to do two things.
1) automate this so it runs everyday at a set time
2) not have to click the save button when the dialog box pops up looking for a save location.

Is this possible? Thank you!

[pbaldy]

1) I'd create a db that performed the desired functionality when it started, then quits. Then I'd run that from Windows Scheduled Tasks.

2) Probably possible, depending on what method you use to create the file. I use OutputTo in VBA which doesn't create any prompts.