[VBA] How to convert an Excel woorkbook completely from Excel 2003to Excel 2007?

[Peter Müller]

I have an Excel 2003 workbook and save it as xlWorkbookNormal with .xslx
extension. Although the saved file can not be read by Excel 2003 anymore
the contained worksheet still can have only up to 256 columns. And
therefore I cannot copy an Excel 2007 worksheet in that workbook.

 

[Jim Rech]

xlWorkbookNormal is .xls format. Save it in xlOpenXMLWorkbook or
xlOpenXMLWorkbookMacroEnabled format.

 

[Don Guillett Excel MVP]

Save as .xlsx>>close>>reopen>>

 

[Peter Müller]

Save as .xlsx>>close>>reopen>>

Thanks
that helps.