Auto Report To Excel ..

[GUIDO22]

I need to generate an Excel report but NOT using the shortcut menu and Wizard in access... From report preview...

I want to be able to use vba to run the access report and automatically save the excel report to a designated folder on disk.
(I have another routine i can use to then email the file on...)

So one command button press will do the lot!

Any ideas please?
Thanks in advance.

 

[bastanu]

Look into adding Docmd.OutputTo to your button's Click event:

Access VBA DoCmd.OutputTo Method - Access-Excel.Tips

This Access tutorial explains how to use DoCmd.OutputTo Method to export different objects to specific file types, for example, export Query to xlsx

access-excel.tips

Cheers,