IIIm using TDA 2.5.1 to run some reports. In the Automation tool, when I export the result to Excel, it adds only a tab to existing Excel file, if the file name you want to use previously exists. Instead of adding a tab, I want the file to be replaced (since the report is being saved in a shared drive) and the report is becoming too big every week.
The feature has been added to our latest version of Toad 2.6.1 that is available for download on our support link web site. In this version, there is an option to "Clear worksheet data before exporting" in the export wizard for the Automation.
,
