Hi,
I'm looking for a way automatically save an excel sheet with a date i
the filename for easy identification. id like it to follow the forma
below
dd-mm-yy Stats.xls
the code i have is:
Sub SaveDate()
ActiveWorkbook.SaveAs Filename:= _
"C:\Documents and Settings\Andrew\Desktop\" & Format(Date, dd
mm - yy) & "Stats"
End Sub
The problem i have is that it saves as the number which excel generate
for dates so if it was the 1/1/1900 it would save as 00001 stats.xls
obviously i cant have the date as 1/1/1900 stats.xls as windows wouldn
accept it
any ideas?
thanks in advanc
--
andywalke
-----------------------------------------------------------------------
andywalker's Profile:
http://www.excelforum.com/member.php...fo&userid=2441
View this thread:
http://www.excelforum.com/showthread.php?threadid=38218