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
|