View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrew Andrew is offline
external usenet poster
 
Posts: 358
Default Getting filenames via VBA

Hi,

Is there an easy way to get the filenames (in a text file) if I quote the
path. For example if I know the path is C:\Andrew can I get a flat file with:

C:\Andrew\file_a.txt
C:\Andrew\file_b.txt

Can we take it one step further and get all files on a drive if I don't know
the path but I do know the drive (C:\). Then you may get:

C:\Andrew\file_a.txt
C:\Andrew\file_b.txt
C:\Smith\file_a.txt
C:\Smith\file_b.txt

Thanks in advance.



--
Andrew