View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Techno Techno is offline
external usenet poster
 
Posts: 2
Default How to Import the path of files (100) in single folder to excel

I have multiple folders containing multiple files & subfolders inside.
Is it possible for me import the path's of all the files & subfolders in an
excel sheet.
eg. I have 20 files and 5 folders in "My documents"
i need the exact path of the 20 files in different cells of excel + same
with the files in the 5 subfolders

It is quite difficult to do see properties for each file and insert it in
the cell.