Export to directory, which created by date

hyperpower

New Member
Joined
May 8, 2013
Messages
18
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!
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

mvsub1

Board Regular
Joined
Jan 15, 2011
Messages
64
Hello hyperpower,

try this:

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

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,925
Members
414,416
Latest member
Nobu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top