Code for link excel spreadsheets

  • Thread starter Thread starter SAC
  • Start date Start date
S

SAC

I have a set of 11 spreadsheets that I receive each day. I save each day's
set in a sub folder from where the mdb resides.



Currently a set is linked as tables in an mdb along with other tables.



I would like to write some code where I can select the folder where a set is
and then have them relinked to the mdb.



I don't know if this is possible since I don't need to relink all tables in
the mdb, just these. The other tables are linked to tables in another mdb.



Is this possible?



If so can you point me in the right direction as to how to go about it?



Thanks.
 
I'm getting it.

I'm using a combination of the browsefolder function I found on the Access
Web website and the Dir function and parsing the tbl.connect property.

Thanks anyway, though.
 
Back
Top