Save Workbook (Blist) as today's date
 

I have a workbook called a BList that I produce every Monday
I want to save it as the current date:
e.g.BList 09/12/04
Can someone help, many thks in advance

sub toda()

Thisworkbook.saveas ....

end sub

Save Workbook (Blist) as today's date
 

ThisWorkbook.SaveAs "c:\myfolder\BList " & Format(Date,"dd-mm-yy")

"/" is not accepted by Windows in the file names.

KL

"teresa" wrote in message
...
I have a workbook called a BList that I produce every Monday
I want to save it as the current date:
e.g.BList 09/12/04
Can someone help, many thks in advance

sub toda()

Thisworkbook.saveas ....

end sub