Export different report to different folders

[maabbas]

I have some reports with criteria and I want these report to save as PDF in different folders on network

Currently I am using the button and following code to export report.

Private Sub Command1_Click()
DoCmd.OutputTo acOutputReport, "Report1", acformatepdf, "C:\Users\TestUser1\Desktop\Test1.pdf", True
DoCmd.OutputTo acOutputReport, "Report2", acformatepdf, "C:\Users\TestUser2\Desktop\Test2.pdf", True
End Sub

Is there any way someone help me to figure out how to do this operation automatically on specific time.

Thanks

 

[pbaldy]

I typically create a limited copy of the db that does the desired process on startup and then quits, and call that from Windows Scheduled Tasks.

 

[maabbas]

I typically create a limited copy of the db that does the desired process on startup and then quits, and call that from Windows Scheduled Tasks.

Thanks for reply, will you please explain little more?