OK I have a minor problem with the saving as the date.

Using sFilename = Date & ".xls"


It tried to save it in this format 7\11\2005.xls. This would be fine
but it won't save this way as it thinks it is a folder with the \

Do I have any other options or is it a setting in Excel that has to do
with the way the date is saved?



thanks


--
MegaDETH
------------------------------------------------------------------------
MegaDETH's Profile: http://www.excelforum.com/member.php...o&userid=25004
View this thread: http://www.excelforum.com/showthread...hreadid=385289