VBA to list top level folders

[scotthannaford1973]

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

 

[Kerryx]

You can use Power Query , just