Toad World® Forums

Executing Excel Macro after Toad builds spreadsheet

Hi. I’m using an app in Toad for Oracle 12.11 to build queries and then export results into a spreadsheet. I have developed an Excel macro that does a few things like formatting and calculating some additional data on the report. Is there a way I can have Toad call the Excel macro once the spreadsheet is built before it is emailed as part of the Toad app?

Thanks,

Steve

There’s no way to do it directly from Toad, but if there is a way to call a macro from command line, you could add an action in Toad to do that. We’ve got a “Shell Execute” action on the “Utilities” tab.