Exporting to Excel

  • Thread starter Thread starter Rajesh Candamourty
  • Start date Start date
R

Rajesh Candamourty

Dear All,

I have a database with 10 reports. All the reports have an option that can
be exported and viewed in a spreadsheet. I used DoCmd.OutputTo function.
Everything works fine. But, after I generated 4-5 reports in Excel then it
gives an error saying the filename already exists. If i go in the debug mode
and press F8 it works fine. To my understanding I think it is not
overwriting the file after certain count. Can anyone tell me how do I tackle
this situation or is there any command to overwrite the file?

Thank you.
Raj.
 
Look in Access Help for "FileSearch" - This will give you the ability to look
for a file and determine if it already exits before writing over it.
 
Back
Top