I have some old .xls Excel files that I need to merge into one file and saved as a .xlsx file. The .xls files are of verion 97-2003 and the .xlsx file i like to be 2010 version. After the merge I find out that some background colors have changed, and some shapes has changed also (although the color of the shapes remain the same). I tried the following:
dim xlBook as new WorkBook()
xlBook.Version = ExcelVersion.Version2010
... do the merging using AddCopy
xlBook.SaveToFile(filename, ExcelVersion.Version2010)
This does not work correct the background color problem, any suggestion?