Exporting Quickbooks reports to Excel macro-enabled workbooks
I spent considerable time on the computer and on the phone yesterday trying to figure out how to get a Quickbooks report exported to a macro-enabled workbook. (Workbooks with macros must, since Office 2007, be saved as "macro-enabled", or the macros won't be saved with the file). The .xlsm file type is not a selectable option when exporting. But, Quickbooks will allow you to waste the time to click on the "Excel -> update worksheet -> browse for file -> select worksheet" process before the system finally tells you the file type is unsupported.
This is not a Quickbooks problem, but it does seem like Intuit support should be aware of the problem. The workaround is to save your Excel file as a 1997-2003 file, which is .xls type but which allows macros.