Export to directory, which created by date

[hyperpower]

Hi All!

I am new here, hope to find an answer and/or help to my question.
What I would like to do is creating a macro, which saves file (this part is done) to a specified directory (this is a bit tricky, this is what I can not write in VBA).

Here's an example: there is dir C:\TEMP\, this is already created. I would like the macro to save files into a folder, which is a subfolder of C:\TEMP\ and the subfolder dirname is based on today date, e.g.: C:\TEMP\08-May\; C:\TEMP\09-May\...

Please help me, any ideas are welcome, thanks!

 

[mvsub1]

Hello hyperpower,

try this:

mydate = format(date(),"dd-mmm")
mypath = "C:\TEMP\" & mydate & "\"
MkDir mypath

 

[hyperpower]

Hello hyperpower,

try this:

mydate = format(date(),"dd-mmm")
mypath = "C:\TEMP\" & mydate & "\"
MkDir mypath

Hi mvsub1,

Thanks, this works nice!