Link to home
Start Free TrialLog in
Avatar of error_prone
error_prone

asked on

Create A New Folder Using VBA and Excel Cell Reference for Folder Name

Is it possible to create a new folder where the path name is in an Excel cell?  Also, the folder name would be the current date in this format, "YYYYMMDD".
ASKER CERTIFIED SOLUTION
Avatar of Saurabh Singh Teotia
Saurabh Singh Teotia
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of error_prone
error_prone

ASKER

How do I change the msg "Folder Exists" to basically have it keep going?  Type in Resume Next?
Enter your code after end if that is after line-16 and it will keep on going the code after the message and if you want to remove the message then change the line-11 that is completely remove it which will remove the message.
Saurabh...
Thanks!