docmd.outputto error

N

neo0210

Dear all,

When I use "docmd.outputto acOutputReport, Screen.ActiveReport.NAME,
acFormatXLS, GetProgDirPath + (Screen.ActiveReport.NAME) + ".xls", False" to
export report to excel file.
I can't open the excel file since it prompt " this file need repare,invalid
sheet name",and the sheet name is "recovered sheet1".
How can I get the right excel file when I use docmd.outputto?
and can I add the password to this excel file?
Thanks very much.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

outputto excel error 4
Export report to excel ERROR - please help 3
Invalid Sheet Name on Export 1
Exporting Access Rpts to Excel 2
Report export issue 2
Access 2007 acFormatXLS not working 7
Report Error With No Data 6
Saving to SnapShot / Excel etc. (A97) 3

Top