Hi All.

One of my Excel apps has some "Go To" functionality in it. I am using
the following code to open a browser window to an address in a web
application that we are using:

ThisWorkbook.FollowHyperlink Address:=sLinkInit & Cells(ActiveCell.Row,
iInitCol).Value, NewWindow:=False

The problem is that every time this code executes, it opens a new
browser window and does not reuse the existing browser window that is
already open. So depending on how many times the user executes the "Go
To" functionality, they can end up with a bunch of browser windows open
to my web app.

I need some help building a function that will test to see if a browser
window is already open, and if there is a browser window open, use that
window for the FollowHyperlink method.

Any help at all would be greatly appreciated!

TIA,
Eric


--
EricIsDeliriou5
------------------------------------------------------------------------
EricIsDeliriou5's Profile: http://www.excelforum.com/member.php...o&userid=15623
View this thread: http://www.excelforum.com/showthread...hreadid=271682

In my experience,
The Newwindow argument only pertains when Excel is opened in a browser. It
doesn't sound like that is the case for you, so it won't work that way.

--
Regards,
Tom Ogilvy

"EricIsDeliriou5" wrote in
message ...

Hi All.

One of my Excel apps has some "Go To" functionality in it. I am using
the following code to open a browser window to an address in a web
application that we are using:

ThisWorkbook.FollowHyperlink Address:=sLinkInit & Cells(ActiveCell.Row,
iInitCol).Value, NewWindow:=False

The problem is that every time this code executes, it opens a new
browser window and does not reuse the existing browser window that is
already open. So depending on how many times the user executes the "Go
To" functionality, they can end up with a bunch of browser windows open
to my web app.

I need some help building a function that will test to see if a browser
window is already open, and if there is a browser window open, use that
window for the FollowHyperlink method.

Any help at all would be greatly appreciated!

TIA,
Eric


--
EricIsDeliriou5
------------------------------------------------------------------------
EricIsDeliriou5's Profile:
http://www.excelforum.com/member.php...o&userid=15623
View this thread: http://www.excelforum.com/showthread...hreadid=271682