ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Getting list of directories (https://www.excelbanter.com/excel-programming/299873-getting-list-directories.html)

mousetrap

Getting list of directories
 
Hi,

I need a VBA macro (to be used from within excel) to get a list of all
directories within a specific directory.

Thanks

_________
MouseTrap

Rob van Gelder[_4_]

Getting list of directories
 
I have an example on my website: "List (Sub)Folders"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"mousetrap" wrote in message
...
Hi,

I need a VBA macro (to be used from within excel) to get a list of all
directories within a specific directory.

Thanks

_________
MouseTrap




Tom Ogilvy

Getting list of directories
 
Another source:
See the Excel VBA help example for the Dir command

--
Regards,
Tom Ogilvy

"mousetrap" wrote in message
...
Hi,

I need a VBA macro (to be used from within excel) to get a list of all
directories within a specific directory.

Thanks

_________
MouseTrap





All times are GMT +1. The time now is 02:24 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com