Populate a tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to Populate a table with the names of excels file in a directory.

storing directory name & file name.

Thanks for help
 
Hi Trever

You can use the Dir() function in a code loop to return all of the files in
a dirctory which match a certain specification (eg *.xls). Then, in your
loop, write code to append a new record for each file.

Check the online help for Dir for an example of how to use it with
wildcards.
 
Back
Top