There is no easy way to do this, as what you need is the ability to specify a worksheet to delete first, before you add the new worksheet based on todays date.
That would have to be done in script.
Is the problem that there are other worksheets in this file, as well as the one that (presumably) always reflect todays date, so you cannot simply overwrite the file?
What I want to do is 'add data to file' and 'overwrite table' in file: 'table.xls'. But I want to export table.xls as the name 'table[&yy][&mm][&dd].xls'. The problem is that it will try to create a new table if I use the date. Is there anyway to do this easily? I can think of some complicated ways, but I wanted to make sure there wasn't an easy way. /b[/quote]