Want to open new hyperlink in existing IE window and tab

[flyboy54]

I have a series of hyperlinks to a defect database. When the first one is clicked, I am prompted to log into the database.
When I click a second one, I want to use the existing open IE window and Tab but refresh the hyperlink with the new value so I don't have to log in.
Is there a way to do this using VBA from Excel?
I could have the user double click the link to invoke the hyper link or use On_Click.
Thank you.

[Leith Ross]

Hello flyboy54,

Do you want to click the hyperlink in the IE window?

[flyboy54]

Leith,
What I would like to do is the following:
1) When the user clicks a hyperlink in the excel spreadsheet test to see if an IE window to the data base is already open
2) If it is open, replace the address (which include the defect ID) wht the hyperlink from the cell just clicked and refresh IE
3) If it is not open, behave the way exce does now, that is open IE with the hyperlink value. The user will then log in.

On subsequent clicks of hyperlinks, go back to #1 and repeat.
Does that clarify what I am trying to do?
Thank you.