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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Auto Populate a Field 1
DLookup Issue 9
VBA - retrieve data on last create named range from previous inserted named range 0
ListBox 2
Filling a combo box list 2
Populate 2 fields from another field. 3
Populate 2nd table from form 1

Back
Top