.XLS to .XLSX Error
Posted on 2014-01-10
Two workbooks are created from a third party program. Initially, they are created as an .xls file. Each workbook is reformatted, through a VBA macro, with the button on the QAT. The macro is located in PERSONAL.xlsb. Workbooks 1 and 2 are saved as a .xslx file through the macro. No code exists within the workbook.
Manually, a worksheet from workbook 2 is copied to workbook 1. No changes are made to this worksheet.
1. Workbook 1 is again saved as an .xlsx file after the worksheet is copied to it.
2. In attempting to reopen this closed workbook 1, an error appears that workbook 1 is either in the wrong format, or corrupted.
Initial work around....
1. To solve this, the workbook is renamed to .xls and reopened, then resaved as an .xslx file.
2. After performing this process, the workbook will open correctly.
This is problematic as most of this process is done within VBA, and others who will be using this code, eventually won't, if they have to rename and then resave, or it is just left in the .xls format...which is taking a step backward.