View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
suyog_linux suyog_linux is offline
external usenet poster
 
Posts: 7
Default How to write directory structure to excel file

Hi All,

I would like to know how can i extract the whole path info of all
the files and subdirectories in a directory to a excel file.


Please help me with this.


e.g. I have following directory structure
c:\test contains 1 or more subdir and 1 or more files


Subdirs also contain files and subdirs ... i want info about all this
when i enter param as c:\test ...


Column 1 should contain file name and column 2 should contain path from



root folder.


thanks,
Suyog