By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,158 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

coding links in VBA

P: n/a
What is a good way, in VBA, to automate the linking of table links to
excel spreadsheets that reside in the same path as the database file
that would be common to Access97 and Access2000 so that if the
database directory were to change, the links would still be valid at
query time?

Thanks in advance,
Chas
Nov 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
ChasW wrote:
What is a good way, in VBA, to automate the linking of table links to
excel spreadsheets that reside in the same path as the database file
that would be common to Access97 and Access2000 so that if the
database directory were to change, the links would still be valid at
query time?

Thanks in advance,
Chas
I think the .Connect property is the thing you are looking for.
Nov 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.