Macro to create a forder with date name

[Cristy]

Hi,

I whant to make a macro that will run when I open file.
This macro must create a folder in a location and the name wiil be the date when the macro run

can anyone help

Thx

 

[marka87uk]

Try something like this...

MkDir "C:\" & Date

 

[marka87uk]

Actually Date will provide the date in a format of 24/08/2011 and as folder names cannot contain '/' then you'll need to format the date differently like so:

Private Sub Workbook_Open()
MkDir "C:\" & Replace(Date, "/", "-")
End Sub

 

[Cristy]

Is not ok

 

[Cristy]

Yap it's working

thx