View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Map/List of folders, subfolders & files

Bogdan,
You may want to try the free Excel add-in "List Files".
It list folders & files or just folders. The file list is hyperlinked.
The list can be sorted.
Download from... http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"Bogdan"
wrote in message
Hi there,

I'd like to create a VBA code, which should generate the map of all folders
and subfolders (and their subfolders and so on) of a particular folder, say
C:\.

The case is like this: I have a folder containing more than 100 subfolders.
Each subfolder also contains a variable number of subfolders (from 1 to 20)
and so on. The thing is that the total number of folders and subfolders is
huge and I have to keep them under control.

Can anybody help me?

Thanking in advance,

Bogdan