Open Intranet page with Excel

[Guest]

Good morning, i am opening an application inour intranet, successfully, from
excel with the following:
ActiveWorkbook.FollowHyperlink Address:= _
"https://b2b-portal.muc/baans/jsp/b2b/b2b.jsp?language=en"
I would like to know if it is possible, if i ask the user for his password
and put it into the address with a variable if it would work ??

 

[Rob ^_^]

Hi Les,

The usual way to pass data to a web page is with parameters.... see your
example
the ?language=en is a parameter.
If you wrote the b2b.jsp you could add your password and username to the
list of parameters for the page to process. eg.
b2b.jsp?language=en&secret=%23%26%78%&UserId=98764534

Contact your web developers who authored b2b.jsp (WebSphere? HAL
contractors?). You can then add your user and password prompts to your
spreadsheet. Don't forget you have to handle an invalid login which you
cannot do from excell.... the best solution is to take them to the b2b.jsp
page and get the user to enter their credentials there.

Regards.

 

[Guest]

Thanks so much for the reply Rob, much appreciated...