shockandawe
10-27-2011, 07:16 PM
I have an existing program with the following line of code...
Set NewWB = Workbooks.Add
I'm using Excel 2007.
When I execute the code above, Excel adds a new workbook in compatibility mode (the workbook has 65,536 rows of data).
How can I tell VBA that I want the new workbook to be XLSX format? I don't want to save the file as xlsx and open it up again as this is part of a loop and would result in saving/opening hundreds of files.
Thanks.
Set NewWB = Workbooks.Add
I'm using Excel 2007.
When I execute the code above, Excel adds a new workbook in compatibility mode (the workbook has 65,536 rows of data).
How can I tell VBA that I want the new workbook to be XLSX format? I don't want to save the file as xlsx and open it up again as this is part of a loop and would result in saving/opening hundreds of files.
Thanks.