Hello Experts,
I'm looking for creating month folders to Online SharePoint.
I have around 100+ folders of supplier names. Into each supplier folders there are folders 2017 to 2019. And into each year folder there are folders from January to December.
Now I want to have a VBA code which will go into each supplier name folder > then create 2020 folder > and then create January to December folders.
How can this be done ? Thanks !
Map your SharePoint path as a local drive (web search How to map a SharePoint drive)
In the code below, change the mapped drive and path to your root folder containing your suppliers
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
@AlphaFrog,
Thank You ! i just mapped SharePoint path as a local drive to my computer and added the URL intoThis did the trick to create folders to SharePoint as well to Shared Drive.Please Login or Register to view this content.
Thanks ! once again.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks