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.