Create folder with System Date

Good evening cartotech

...and welcome to the forum!!

Originally Posted by cartotech81

I am trying to create a folder in Excel using the system date only. Do not need the time. Also once that folder is created I want to be able to move my save as directory to the new folder so all the files that I try to save from excel will go to this new folder.

You haven't stated what format you want the date in, so this will use "dd-mm-yy" - just amend the code to suit :

Please Login or Register  to view this content.

HTH

DominicB