Executing Excel Macro after Toad builds spreadsheet

Toad for Oracle
1

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

2

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.