declare @filename nvarchar(100)

set @filename = 'c:\test.' + convert(varchar(10),getdate(),102) + '.xls'

print @filename

Then examples of using bcp or rowset

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926