I am using a loop to export results and at present I end up with three results files, SalesTW.csv, Sales LW.csv and SalesLY.csv.
These files need to end up in a spreadsheet on a single tab called DATA, clearing whatever was in that tab previously. Now I can do this with a vb script but I was wondering if TDA can handle this?
I have just experimented with using the export to Excel file and the various options in there, which I have got to clear down the DATA worksheet and then insert the files but as it loops round the previous export is cleared, so when its finish all I end up with is the last file to be exported in the DATA tab, i.e. only a third of my output.
Is anyone able to advise?