Save Workbook (Blist) as today's date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
ThisWorkbook.SaveAs "c:\myfolder\BList " & Format(Date,"dd-mm-yy")

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

KL
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference active worksheet from macro in personal.xls 2
error 1004 2
Finding Last Date Report 1
Excel is changing date format incorrectly 7
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
Private Sub Workbook_BeforeSave 2
Saving a workbook 6
SAVE AS MACRO 6

Back
Top