B
Bad at VBA
Hi,
I am exporting data from an Access 2007 database into Excel 2007 .xlsx
format and as part of the export I select the keep formatting option.
Everything seems to work fine, but when I try to open the .xlsx file I
get the following errors:
"Excel found unreadable content in 'spreadsheet.xlsx'. Do you want to
recover the contents of this workbook? If you trust the source of this
workbook, click Yes."
I click Yes, then get a dialog box labeled "Reairs to
'spreadsheet.xlsx'. The dialog shows:
Repaired Records: Format from /xl/styles.xml part (Styles)
I know that's not a lot to go on, but does anyone have any ideas on
how I could resolve the situation, other than turning off the "keep
formatting option" as part of my export from Access?
Thanks!
I am exporting data from an Access 2007 database into Excel 2007 .xlsx
format and as part of the export I select the keep formatting option.
Everything seems to work fine, but when I try to open the .xlsx file I
get the following errors:
"Excel found unreadable content in 'spreadsheet.xlsx'. Do you want to
recover the contents of this workbook? If you trust the source of this
workbook, click Yes."
I click Yes, then get a dialog box labeled "Reairs to
'spreadsheet.xlsx'. The dialog shows:
Repaired Records: Format from /xl/styles.xml part (Styles)
I know that's not a lot to go on, but does anyone have any ideas on
how I could resolve the situation, other than turning off the "keep
formatting option" as part of my export from Access?
Thanks!