Connecting to Intranet via Excel

Vas · May 13th, 2002, 07:19 AM

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?

Asala42 · May 13th, 2002, 07:57 AM

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

Chris Davison · May 13th, 2002, 08:49 AM

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 ?

Vas · May 13th, 2002, 08:52 AM

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

Asala42 · May 13th, 2002, 08:55 AM

Hey again,

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

Adam

Vas · May 13th, 2002, 09:12 AM

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 ]

May 13th, 2002, 07:19 AM	#1
Vas Board Regular Join Date: May 2002 Location: Gothenburg, Sweden Posts: 74	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

May 13th, 2002, 08:49 AM	#3
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	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 ::

May 13th, 2002, 08:52 AM	#4
Vas Board Regular Join Date: May 2002 Location: Gothenburg, Sweden Posts: 74	Thanks for yoour interest. Chris, the password is required to get into the Intranet. __________________ /Niklas Jansson

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 13th, 2002, 07:57 AM	#2
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	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

May 13th, 2002, 08:55 AM	#5
Asala42 Board Regular Join Date: Feb 2002 Location: Southfield,MI USA Posts: 1,027	Hey again, Can we see some of your formulation? A before and after maybe? Adam

May 13th, 2002, 09:12 AM	#6
Vas Board Regular Join Date: May 2002 Location: Gothenburg, Sweden Posts: 74	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 ]