Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default How to find folders in a directory

Can someone show me how to write a code which will find all the
folders in a given directory and then write those folder names onto
the active worksheet? I know how to do files, I just need the
folders.

thanks,
Andy
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 236
Default How to find folders in a directory

Have you had a look at Chip's brilliant site
www.cpearson.com/excel/foldertree.aspx
?

On Mar 17, 1:18*pm, Andrew wrote:
Can someone show me how to write a code which will find all the
folders in a given directory and then write those folder names onto
the active worksheet? *I know how to do files, I just need the
folders.

thanks,
Andy


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 130
Default How to find folders in a directory

On Mar 17, 7:22*am, AB wrote:
Have you had a look at Chip's brilliant sitewww.cpearson.com/excel/foldertree.aspx
?

On Mar 17, 1:18*pm, Andrew wrote:

Can someone show me how to write a code which will find all the
folders in a given directory and then write those folder names onto
the active worksheet? *I know how to do files, I just need the
folders.


thanks,
Andy


AB,
Thanks. That looks like what I am looking for.

Andy
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy files in sub folders to a specific directory andreashermle Excel Programming 1 June 28th 10 10:22 PM
Using VBScript to list all folders in a directory and files ... scriptman Excel Programming 1 July 23rd 07 02:49 PM
Find Folders SteveW Excel Programming 1 November 17th 05 04:34 PM
List of folders in a certain directory woolyhedgehog Excel Discussion (Misc queries) 1 October 19th 05 04:28 PM
Stop directory & folders changing in link when moving file - Bella Excel Programming 0 July 14th 05 04:13 PM


All times are GMT +1. The time now is 06:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"