Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Link Problem (Off 97)

    Hi all,

    Situation:

    I am running a macro in access that outputs some querys to excel files we have on our shared drive. I want to use these 5 files as the backbones for a new file that will have links to the separated data and fornat it nicely into a table.

    Problem:

    From my computer I can not create any links from my Quarterly Issues file to those separated data files. The Quarterly Issues file is where the links should all be summing up the other output files. i always get the error :

    The folder 'C:WINNTProfilesEdwardPersonal[Past Issues by Division.xls]Priority of Open Due' isn't accesible. The folder may be located on an unavailable volume or protected with a password.

    Stumpers:
    The odd thing is if I try to link from another computer on the network there is no problem., the links work how they should. Also in that error message the file ('C:WINNTProfilesEdwardPersonal[Past Issues by Division.xls]Priority of Open Due' ) that it says isn't accessible is not where that file is even located. It is telling me that the file i am linkning to is not accessible but it is checking the wrong place. The files are actually saved in (G:MetricsPast Issues by Division.xls). So excel is looking for a file on my C: when the files that are being linked are actually on the G:. How do i tell excel to stop looking in the wrong place for these files?

    After the error message comes up it allows me to search for the file myself and if i map it to the correct file on the G: i get an unable to read file error. It is an endless circle of errors, does anyone have any suggestions to get my output files linked to another file. Why can i do it form other computers, just not mine?

    Thank you Ed

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Link Problem (Off 97)

    I am unclear - are the errors occurring while you are in Excel or Access?

    Happy New Year
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Silver Lounger
    Join Date
    Apr 2001
    Location
    New York, New York, USA
    Posts
    2,328
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Link Problem (Off 97)

    Inserting the link, type the full path
    "G:MetricsPast Issues by Division.xls"
    not only "Past Issues by Division.xls" Without full path, Excel starts looking where it is open (from Priority of Open Due).

  4. #4
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link Problem (Off 97)

    When i tried to make the links in excel. This is after they were outputed by access to their destination. ALL access does is output to that file. I am in excel and i hit = in a cell on one page and try to put a link to another excel file and then the errors occur.

  5. #5
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link Problem (Off 97)

    Been there done that and i still get the same error that the folder/file i specified wasnt accessible or may be password protected. Then the pop up screen occurs and it lets me find the file, when i do i get a could not read file error. any clues?

  6. #6
    2 Star Lounger
    Join Date
    Jul 2001
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Link Problem (Off 97)

    ends up the problem existed because the name of the sheet it was looking in had a " " it so excel thought i was calling a new directory when in fact that was just the name of the sheet, thanks for the help though.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •