I would suggest you save files that have dates in their filename
that you use for format to name the file so that you have
year first, followed by month then day of month so that
they will sort nicely as filenames regardless of your last update date.
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MegaDETH" wrote in message
...

That worked !!


Thank you again for your help


Henry Wrote:
MegaDeth,

Sorry,
I forgot that the slashes can't be used in a filename.

2 ways around that.

1) Control PanelRegional and Language OptionsRegional
OptionsCustomizeDateDate Separator = .
This will change your date format to 7.11.2005 (throughout windows)

2)sFilename = Month(Date) & "." & Day(Date) & "." & Year(Date) &
".xls"

Henry



"MegaDETH"
wrote in
message ...

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



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