| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
quick list of directories..
Thanks, Harald.
I think "If GetAttr(sPath & sDirName) = vbDirectory " will do exactly what I need, at a good speed. The f.Subfolders property I mentioned first was unusably slow. Thanks for your help. Mark "Harald Staff" wrote: Afaik Dir is as fast as it gets in Windows. See http://www.dicks-blog.com/archives/2...attr-function/ for code. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create list from directories | Excel Discussion (Misc queries) | |||
| File Open doesn't display all directories (List vs Details) | Excel Discussion (Misc queries) | |||
| Quick Jump to end of list... | Excel Worksheet Functions | |||
| Creating a list of directories | Excel Programming | |||
| Getting list of directories | Excel Programming | |||
Threaded Mode
