Hi,
Can anybody let me know how to create a new folder with current date ? and also how to move all the .csv files i have in one folder to another. Thank you.
Regards,
Jeffrey
Hi,
Can anybody let me know how to create a new folder with current date ? and also how to move all the .csv files i have in one folder to another. Thank you.
Regards,
Jeffrey
This will create a new folder
You could create a loop to move the files. If no-one does it for you I will have a look at it after work![]()
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for the help. Have tried the code, however there is an error saying that the path not found. Have been fooling around with the code for few hours and did not get it working.
Please read forum rules
This is a small extract of Rule 3
More detail of where you needed to create the folder would have resulted in a more detailed answer that was more suited to your needsRule 3). Ensure Your question is not too vague
Roy's code gives 2 ways of creating the folder
Remove whichever line of code does not suit your needs
creates a new folder in the active folder
Create a new folder in a different location![]()
Please Login or Register to view this content.
change C:\My Documents\ to suit
Another option![]()
Please Login or Register to view this content.
Create folder in Excels default folder
![]()
Please Login or Register to view this content.
For moving files
try this macro
Change paths as required
![]()
Please Login or Register to view this content.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Hi,
Thanks for your help. I have tried that before ( commenting one of the line out) but to no avail i am afraid.
Regards
Jeffrey
FOUND THE ERROR. Was me foolishly entered the wrong directory !! Can you also let me know how to save file to my newly created folder ? save to folder by date ? is that possible ? thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks