Automatically saving a report as an excel file

[p595659]

Hi,
I was wondering if there was a way for a report to be automatically saved as an excel file. Also, the Access database is stored on the company's server so would you be able to choose the path where the excel file would be stored?

Cheers,
Ben

 

[ghudson]

Searching the forum is a great way to discover and learn the answers to your Access programming questions.

Just use the TransferSpreadsheet() function to output the data source of your report. This should help you select a directory for the output... Browse [Find a directory or file]