LINKED file how will it be found?

[Guest]

I have an xl file linked to one of my mdb forms how do I make it available to
other users when I distribute the database? It isn't recognized because it
is not in the same location on their harddrive. I tried 2 different options

Application.FollowHyperlink "C:\MyDocs\...\BuildList.xls"
and
Application.FollowHyperlink "...\BuildList.xls"

Neither works it opens excel but doesn't find the file.

(I thought this might work since it does work if the file is located in the
same directory when designing a web page)

Any suggestions?
Thanks!

 

[Matthias Klaey]

I have an xl file linked to one of my mdb forms how do I make it available to
other users when I distribute the database? It isn't recognized because it
is not in the same location on their harddrive. I tried 2 different options

Application.FollowHyperlink "C:\MyDocs\...\BuildList.xls"
and
Application.FollowHyperlink "...\BuildList.xls"

Neither works it opens excel but doesn't find the file.

(I thought this might work since it does work if the file is located in the
same directory when designing a web page)

Any suggestions?
Thanks!

See, e.g.,

http://www.mvps.org/access/tables/tbl0012.htm

HTH
Mathias Kläy

 

[Guest]

Thanks I will see if I can impliment it !

See, e.g.,

http://www.mvps.org/access/tables/tbl0012.htm

HTH
Mathias Kläy