Toad World® Forums

Automating Complex Excel Reports


#1

Dec 6, 2010 5:17:00 PM by Debbie Peabody


This is a companion discussion topic for the original entry at https://blog.toadworld.com/2010/12/06/automating-complex-excel-reports-new-in-version-2-7

#2

This is a front page article in Toad’s version 4.2.0.229 “Featured Content” but it is poorly out of date. I am unable to save the export file as an ‘.xlms’ file. Is there an updated blog for the newer versions of Toad? I’m looking to automate an export to excel to refresh a pivot table.
Thank you in advance!


#3

While that blog is old the steps still work. Using macros and *xlsm files are if you want to add customized code before or after the export. You would need to create the xlsm (excel macro enabled file) in Excel before you used it in the export. Is your pivot table created and refreshed in macro code? if so just add macro to clear data page and then export the data to that page. If you do not want to use a macro see this blog https://blog.toadworld.com/2013/04/09/toad-data-point-automation-series-4-excel-pivot-grids