Show us how you'd do it in Access VBA. I'm betting it's much the same. Post
what you have and we can assist.

Barb Reinhardt

"MCI" wrote:

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.