Send URL from Excel to Open Web Page

[jeffandtamara]

I need to send a url to Internet explorer from VBA, which is already opened and logged in to an applicaiton.
I am guessing there might be a very direct way to do this,,,I can manually cut and paste and I get the desired results....

 

[Gino_Vernisci]

Hi Jeff

I'd like to help but I need some more information. If you format the cells containing the URL as a hyperlink and simply click the hyperlink why does this not accomplish your goal?

If the website has a login requirement then it seems like we should be able to open the website in one IE window, log in and leave it idle. Then open the hyperlink in a different window. Because your IE cookies already know you are logged in, the website should not prompt you again.

If it must be done in VBA then I have had success with this code in the past...

Set IE = CreateObject("InternetExplorer.Application")
Application.Wait Now + TimeValue("00:00:01")
IE.Visible = True
IE.Navigate "[URL="http://relmgmt.worldnet.ml.com/relmgmt/SearchCP.aspx"]YOUR URL[/URL]"

I use the "Application.Wait" because my computer takes a moment to actually pull up the IE window before I can send an address.

More info on where you are running into trouble would help.

Cheers
Gino

 

[jeffandtamara]

Thanks Gino...I tried to use a hyperlink...but it just kept brought up a new IE session and had to login again...
It might not be so bad to just cut and paste into the address bar of IE from excel,,,but I sure would like a more elegant solution.....

 

[jeffandtamara]

Gino:
Looks like your code works very close to what I need. One problem or enhancement is that when I run the code multiple times, I get multiple IE browser windows open. Is there code to close IE browser window's....
Anyway, I can live with how it works now,...and Thank You very much!!

 

[Gino_Vernisci]

Good stuff Jeff happy to help

If you end the bit of code that uses the Internet Explorer Window with

IE.Quit

it will close the window. If you want to make the focus of you macro back on to your Excel Spreadsheet try

AppActivate "Name of your spreadsheet"

the "name of your spreadsheet" is the text that appears across the top of the blue bar of the window.