Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: Connecting to Intranet via Excel

  1. #1
    Board Regular
    Join Date
    May 2002
    Location
    Gothenburg, Sweden
    Posts
    74
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a workbook with a number of links to workbooks on the Intranet. The problem is that you have to login through a loginbox.

    When there are links in the workbook, Excel refuses to show me the loginbox, and instead shows a couple of error messages and then just put #REFs in all cells with those links.

    My current solution is to have a "start" workbook, which first tries to open one of the files that demand password - so that Excel will show the loginbox. Then the start-workbook opens the real workbook, and when that's done, it closes it self.

    I find this method rather ridiculous, so I just wonder if there are any other ways to solve the problem?



    /Niklas Jansson

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    G'day,

    Do you have a web-query to that page already? I work with a few files that frequently pull data to a spare datasheet - these usually do toss up a pwd prompt when I try to refresh.

    Hope that helps
    Adam

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Vas,

    is the password required to get into your intranet or is the password required because the file that is being accessed password-protected ?

    if it's the latter, would removing the password-protection be an option ?
    :: Pharma Z - Family drugstore ::

  4. #4
    Board Regular
    Join Date
    May 2002
    Location
    Gothenburg, Sweden
    Posts
    74
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for yoour interest.
    Chris, the password is required to get into the Intranet.
    /Niklas Jansson

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,312
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey again,

    Can we see some of your formulation? A before and after maybe?

    Adam

  6. #6
    Board Regular
    Join Date
    May 2002
    Location
    Gothenburg, Sweden
    Posts
    74
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I wonder if you maybe read my other post, concerning the links being changed when i open the workbook via VBA.

    Anyway, heres the whole story:
    I have a couple of files on the Intranet.
    From these files I want to make consolidations in different aspects.
    In the cosolidation files i have formulas that link directly to the Intranet files.

    When i open the con. files, the links looks at follows:

    ='http://violin.3p.volvo.net/purchasing/perf/kpi/sec-docs/docs/all/[actmac.xls]Chassis'!C$58

    But if I haven't opened any files from the Intranet, Excel just says "Unexpected error", and shows #REF.

    If I open the file via VBA the formulas look like this:

    ='H:Root28xxx281xx28130REP2002Actual[ActMAC.xls]Chassis'!C$58

    (A couple of other formulas change too, they begin with p:/... and is changed to h:/...)

    It seems like people gonna have to open a start file to log in and then open the con. files and then update them (I think I can automate thet part, but still) - this can't be true, can it?


    _________________
    /Niklas Jansson

    Edit:
    I just remebered that the "after" formulas is old ones that have been replaced. It seems like Excel keep those links and use them when I open the file via VBA.
    This is SICK!

    [ This Message was edited by: Vas on 2002-05-13 08:16 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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