Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

LINKED file how will it be found?

Discussion in 'Information Technology' started by lmv, Jul 28, 2006.

Tags:
  1. lmv

    lmv
    Expand Collapse
    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!
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Letter: When terrorism is falsely linked by race or religion, we all become the victims Breaking News Apr 27, 2013
    SciTech Law of Entropy Linked to Evolution of Intelligence Breaking News Apr 23, 2013
    Canada GM corn linked to early death in new study Breaking News Sep 22, 2012
    India set to ban 100 Al Qaeda-linked groups Hard Talk May 17, 2010
    Sikh News Temple linked to terrorists still active (Moldova.org) Breaking News Feb 5, 2008

  3. Matthias Klaey

    Matthias Klaey
    Expand Collapse
    Guest

    lmv <lmv@discussions.microsoft.com> wrote:

    >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
    --
    www.kcc.ch
     
  4. lmv

    lmv
    Expand Collapse
    Guest

    Thanks I will see if I can impliment it !


    "Matthias Klaey" wrote:

    > lmv <lmv@discussions.microsoft.com> wrote:
    >
    > >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
    > --
    > www.kcc.ch
    >
     

Share This Page