Export to Excel problem

A

Adrie ten Bookum

After exporting to an open Excel file from Access, and
have closed the Excel afterwards manually, Excel fails to
properly open an Excel file from Explorer by double click.
The problem appears the same as descriped in "Microsoft
Knowledge Base Article - 811344". This solution doen't
solve my problem.

For the export I have use the following command:
"DoCmd.TransferSpreadsheet acExport,
acSpreadsheetTypeExcel9, strSource, strDestination"

Who has experienced the same problem? And does someone
know a solution? May be I can check for an openfile, but
can't find how to do this.

Thanks,
Adrie
 

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

Export Report with Graph to Excel error 2495 1
Embed the same Excel multiple times 0
Access 2003 and excel 0
Export to Excel when password protected 3
Export to Excel Problem for One User 4
Export Access pivot table to Excel 0
Export Access pivot table to Excel - VBA solution 0
Add Date to export file Name 1

Top