Loop through SparePoint subfolders from Excel VBA using WebDAV
I need to loop through SharePoint subfolders, programmatically from Excel VBA, to get files properties, move files to archive subfolders and replace archived files with new ones. The folder structure is:
MyLibrary/Shared Documents/MainFolder/Subfolders/Archive. First I move files from Subfolders to their respective Archive subfolders, and then I save a new version of the files to each Subfolder, replacing the archived ones. I found methods to move and create files using WebDAV but I need a method to loop through subfolders. Do you have nay solutions to share? Thanks a lot.