Populate a tables

T

Trever B

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

storing directory name & file name.

Thanks for help
 
G

Graham Mandeno

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.
 
Top