Change name of table when exporting to Excel

[smasaitis]

I am using MS SQL Server 7.0 and Excel 2000. I am trying to export a table from SQL to Excel using a DTS package. I can export the table to Excel, but the sheet name becomes whatever the table name is.

I need the sheet name to be a date found in the SQL table.

I get the max date then set it to a variable, but when I try to create the Excel table with this variable name, I am not allowed. I can create a table with a varible name on the SQL side, but not the Excel side.

Any suggestions? I am trying to keep this all in a DTS package.

Thanks.