I need to export data daily in Excel format, the file name
changes every day eg Exportddmmyyyy.xls. This works OK if
you run it manaually but when you schedule it a a Job, it
failes every time. I have a item that deletes the tempory
table and rebuilds it, but as the name changes each time
it always fails when deleting the temp table. Any idea how
to solve the problem