We have a third party software program with some simple custom reports(created by Acess queries from the main d-base). Users can select a custom report in the GUI to execute the report. Then, the third party program program launches Excel and displays in the queried info, but the data needs to be reformatted a bit (adding subtotals, formatting subtotal lines, adding units of measure to the newly created subtotal lines and etc.) through a macro but the macro has to wait till the data is pulled in before it begins. Is this possible? Thanks for any advice