Hi and please help!

I've got a procedure that opens an IE browser window to a specific web page
based on data from a cell and using

Set ie = CreateObject("InternetExplorer.Application")

but then I want to reuse the same IE browser window to repeat the procedure
using data from a different cell. I've tried using

Set ie = GetObject (, "InternetExplorer.Application")

but keep getting Error 429. Ideally I'd like to recognize the active IE
browser window by its Caption/Name because it remains the same for all data
used.

In other words, how do I tell Excel to look for a specific active IE browser
window before opening a new one, and while I have more than one IE browser
window open?

Thanks in advance for any help,

Brian

Brian,
You have your reference (ie) to browser from CreateObject()
Just use that again.

NickHK


"Brian Delaney" wrote in message
...
Hi and please help!

I've got a procedure that opens an IE browser window to a specific web
page
based on data from a cell and using

Set ie = CreateObject("InternetExplorer.Application")

but then I want to reuse the same IE browser window to repeat the
procedure
using data from a different cell. I've tried using

Set ie = GetObject (, "InternetExplorer.Application")

but keep getting Error 429. Ideally I'd like to recognize the active IE
browser window by its Caption/Name because it remains the same for all
data
used.

In other words, how do I tell Excel to look for a specific active IE
browser
window before opening a new one, and while I have more than one IE browser
window open?

Thanks in advance for any help,

Brian

Hi Nick,

Thanks for the reply. Unfortunately, I can't really reference ie that
way. Ideally what I want is

If (web page is already open = ie) Then
ie = GetObject (,"InternetExplorer.Application")
Else
ie = CreatObject ("InternetExplorer.Application")
End If

The title of the web page in the IE browser remains the same for each
intended use (just refreshes with the new data) so I can reference it
consistently

YF = "Yahoo! Finance - Ticker Symbol Lookup"

but I can't figure out how to set that open web page to ie.

Brian



*** Sent via Developersdex http://www.developersdex.com ***

Nick was talking about doing something like this:

At the top of a general module

Dim ie as Object

Sub dowork()
if ie is nothing then
Set ie = CreateObject("InternetExplorer.Application")
End if
ie.this
ie.that

End Sub

--
Regards,
Tom Ogilvy

"Brian Delaney" wrote in message
...
Hi Nick,

Thanks for the reply. Unfortunately, I can't really reference ie that
way. Ideally what I want is

If (web page is already open = ie) Then
ie = GetObject (,"InternetExplorer.Application")
Else
ie = CreatObject ("InternetExplorer.Application")
End If

The title of the web page in the IE browser remains the same for each
intended use (just refreshes with the new data) so I can reference it
consistently

YF = "Yahoo! Finance - Ticker Symbol Lookup"

but I can't figure out how to set that open web page to ie.

Brian



*** Sent via Developersdex http://www.developersdex.com ***