How to use excel vba to specify the path of a link table in access

  • Thread starter Thread starter MCI
  • Start date Start date
M

MCI

In an access database, I have a link table linking to an external text
file. What i want to do is to specify the path of that text file in
vba code in an excel file. I noticed there is a way to do it in a
module in access vba, but i don't know how to do it in excel vba.

Any help would be greatly appreciated. Thanks a lot.
 
Back
Top