I run a daily .tas automation script which exports (‘Select to File’) from a database query to Excel. Every time it runs, it appends a new Excel worksheet to the existing Excel file. I’d like to limit the number of worksheets created, for example to 5, allowing the oldest worksheet to ‘roll off’. I don’t see any such option in the File Options dialog, nor an option to turn off the append. (see attached)
Without such an option, I guess my only option is to ‘Delete File’ prior to each ‘Select to File’?
TDA_Excel_export.ppt (91 KB)