I am attempting to build an automated report that updates a specific worksheet in Excel on a daily basis. All the while maintaining the other existing worksheets. I have followed Debbie’s article Automate Complex Excel Reports at http://dev.toadfordataanalyst.com/webhelp/Content/Automation/Tutorials/Automate_Complex_Excel_Reports.htm
I have successfully managed to get the export to work; however, during the process my remaining worksheets are lost. I was under the impression that this was possible to do with TDP 3.6. Can anyone perhaps provide some insight on how to accomplish this?