I export a report from Quick books to an excel spreadsheet (STR.xlxs) once a week for Sales Tax purposes. I created a Macro to clear the data on all sheets within the workbook and saved as an .xlsm. The problem is Quick books won't let me export to a .xlsm, only .xlsx. So my question is, can I create a Marco in say, "book1.xlsm" and have it clear the data in STR.xlxs? I've attached the workbook with the "clear" macro. Any help on this would be greatly appreciated.
Bookmarks