list folder

Here is the code i found and adapted to my needs and works great. But I want to add an exception, to skip folders starting with ???? and move on to the next folder. Any assistance would be appreciated. So i want: For Each myfile, except. Sub ListMyFiles(MySourcePath, includesubfolders) Set...

I have many folders with the same excel file, which also have same name (logg). How do I list up these files in excel? I want excel to list up these files with folder names in a specific cell. Example: Folder: (Test1) Folder: (Test2) Folder (Test1) logg cell A1 Folder (Test2) logg cell A1...

I have done many searches on how to traverse all files in SharePoint folders using Excel VBA and have not come across an answer I could use because, by configuration design, I cannot map a SharePoint URL to a drive letter. After much trial and error, I came up with a very short solution that...