Still looking for an answer

Posted by Chuck on June 07, 2001 2:55 PM

I want to open up a web site from excel either through a VBA or a Hyperlink. Currently I'm using the following VBA: ActiveWorkbook.FollowHyperlink Address:="https://URL Address of site". The problem is that when I get to the site it wants my ID and password. How can I transmit this data via VBA?

Thanks

Posted by Barrie Davidson on June 07, 2001 3:03 PM

Not sure how to do this (never used this code before) so I looked it up in Help. What about adding the parameter
Extrainfo:="ID and password"

Help says this is an optional variant and states:
"A String or byte array that specifies additional information for HTTP to use to resolve the hyperlink. For example, you can use ExtraInfo to specify the coordinates of an image map, the contents of a form, or a FAT file name."

Hope this helps you out (sorry I can't be of more help).

Barrie