Macro error "External Table is Not in the Expected Format"

D

DHAMM

I have a macro which exports data to a range in an Excel spreadsheet. I have
up-converted the Access database from 2003 to 2007 version, with no apparent
effect on functionality. The macro worked as expected when exporting data to
the 2003 Excel (.xls). I up-converted the Excel 2003 sheet to 2007 and
changed the filename extension in the path for my TransferSpreadsheet macro
command and I get the error message "External Table is Not in the Expected
Format". I can still export to an ".xls" file, but recieve this error message
when trying to export to an ".xlsx" or an ".xlsm" 2007 Excel file.

Any assistance would be greatly appreciated...
 

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

Setting column width in a table with a macro is not working 0
Macro warning in word 1
"External table not in expected format" 7
Excel does not accept text format! 0
"Compile error in table level validation expression " after format 0
Save workbook without shapes 0
Doughnut Chart linked with the slicer in the pivot table 0
excel found unreadable content' error is coming while opening xlsx file 0

Top