Workbooks.Add (xlOpenXMLWorkbook)

[wagnet]

In Excel 2010, the user can define Options/Save/Save files in this format: Excel 97-2003 Workbook. Apparently, this causes the Workbooks.Add Method to open a new workbook in Excel 97-2003 format. I'd like to be able to:

1) Use VBA to query the setting for Options/Save/Save files in this format:

2) Force the Workbooks.Add to open the new workbook in Excel 2010 (.xlsx) format.

Any help, pointers, or direction to syntax/documentation would be appreciated.