B
Bill James
When I open an excel file generated by an Access 2002 query I get th
following message. The default sheet name "Sheet1" is being created i
the workbook by Access.
++++++++++++++++++++++++++++++++++++++++++++++++++++++
Microsoft Excel File Repair Log
Errors were detected in file 'LucCON.xls'. Excel was able to open th
file by making
the repairs listed below. Save the file to make repairs permanent.
The following is a list of repairs:
Renamed invalid sheet name.
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Excel has renamed the sheet name to "Recovered_Sheet1.
The form in Access that runs the Querys via a macro were originall
created under Access 97. We upgraded and converted our database
recently.
I can not find any reason for the error nor how to eliminate it.
Any suggestions and or assistance would be appreciate
following message. The default sheet name "Sheet1" is being created i
the workbook by Access.
++++++++++++++++++++++++++++++++++++++++++++++++++++++
Microsoft Excel File Repair Log
Errors were detected in file 'LucCON.xls'. Excel was able to open th
file by making
the repairs listed below. Save the file to make repairs permanent.
The following is a list of repairs:
Renamed invalid sheet name.
+++++++++++++++++++++++++++++++++++++++++++++++++++++
Excel has renamed the sheet name to "Recovered_Sheet1.
The form in Access that runs the Querys via a macro were originall
created under Access 97. We upgraded and converted our database
recently.
I can not find any reason for the error nor how to eliminate it.
Any suggestions and or assistance would be appreciate