Perhaps I am doing something wrong, but in Toad Data Point, whenever I create an ad-hoc report and use the “One Click Export” tool to transmit the data to an “Excel Instance”, I would then like to be able to quickly run any one of many of my Excel Macros on the data, as soon as the data has finished transmitting to the Excel instance. My Excel Macros are in my file personal.xlsb in the following file structure: C:\Users\xxxxxxxx\AppData\Roaming\Microsoft\Excel\XLSTART . However, when using the One Click Export, the personal.xlsb file does not automatically open, and I always have to open it manually to run the macros. Is there some trick to getting the personal.xlsb file to open along with the One Click Export to an Excel Instance? Please note that whenever I open an Excel File normally, the personal.xlsb file automatically opens in the background, just not when I do the One Click Export from Toad Data Point. Any ideas for me? I am on Windows 7, Excel 2010, and Toad Data Point 3.4.
Thanks,
Richard