Excel error opening workbook

B

Bill James

I am running a macro in access 2002 that performs a query
and exports the information to excel format.

When I try to open the workbook an error is generated from
excel about an "invalid sheet name". Excel renames the
sheet and displays a message you must acknowledge statint
it has corrected the problme. You must then save the
workbook.

This causes errors when I try to run a macro in excel to
import the data into other workbooks.

Any idea why the invalid sheet name is occuring.

Don't know if it has anything to do with this error but I
just recently converted from Excel and Access 97 to Office
XP which uses Excel and Access 2002. The querys and
spreadsheets all work fine except for this one situation.

Also, on the Access macro form you chooose the type of
output. It has one selection that is "microsoft excel
(.xls)" and another selection of "microsoft 97-2002
(.xls). When I choose the 97-2002 selection it still
lists the type as "microsoft excel". Don't know if that is
part of the problem or not.

Any assistance would be appreciated.

Thanks in advance for any suggestions.
 
Top