VBA to list top level folders

S

scotthannaford1973

Board Regular
Joined
Sep 27, 2017
Messages
114
Office Version
  1. 2010
Platform
  1. Windows
Hi

I would like to be able to generate a list of the folders in another folder (path M:/PMO) - just the top level folders in that location, not all the sub folders. Am sure it's easy to do, but I just cannot work it out!

thanks in advance
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
You can use Power Query , just
1677758700071.png
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
VBA listing folders, sub-folders & file names - modification required
Replies
5
Views
557
NdNoviceHlp
NdNoviceHlp
C
  • Solved
VBA Folder Structure -- Loop Once
Replies
2
Views
537
cwhaley1
C
J
  • Question
VBA to List all Folders, Subfolders and files in a directory
Replies
4
Views
1K
Formula11
F
D
  • Solved
VBA to provide links to Folders, sub folders and files
Replies
2
Views
775
davidalldred
D
S
  • Solved
VB to list top 4 levels of folder structure
Replies
5
Views
225
John_w
J

Forum statistics

Threads
1,216,075
Messages
6,128,662
Members
449,462
Latest member
Chislobog

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top