Morning All,
I have a silly little question...
I have a workbook which is 54 worksheets long and was looking for a code that will "duplicate" this book to a new book by iterating through each sheet (whilst renaming) and then saving as an .xlsx file.
Am I overcomplicating things or should i just click file Save as...
Reason why we are doing this is that the original .xls is clearing all formatting when the file is saved hence we assume the file has become corrupt.
Many Thanks
Waqqas
I have a silly little question...
I have a workbook which is 54 worksheets long and was looking for a code that will "duplicate" this book to a new book by iterating through each sheet (whilst renaming) and then saving as an .xlsx file.
Am I overcomplicating things or should i just click file Save as...
Reason why we are doing this is that the original .xls is clearing all formatting when the file is saved hence we assume the file has become corrupt.
Many Thanks
Waqqas
