Excel 2010 VBA Open Intenet Explorer IN Nes Tab, Not New Page

[awsmitty]

I have been trying to solve this problem now for about 2 weeks. I have Googled, searched various forums, searched msdn.microsoft.com, posted several places. I am about to conclude there isn't an answer. Even if that be the case, if someone could tell me it can't be done, even then, that would be a help

I have a spreadsheet that has various company names and financial data on these companies, stock price, P/E, Market Cap, etc. There is a macro in the spreadsheet that when I click on the company name, the macro opens the financial page for that company on Google finance or Yahoo finance. What I'm trying to change is that these webpages all open in a new window. I would like to change that so that they open in new tabs, all on one webpage.

Herre is the code:

As you can see some of the code is now comments, which are previous attempt that failed

Any help, any comments, anything at all, would be a big help and greatly appreciated.

Thanks

[Kyle123]

I think you might be overthinking this one. On my computer, using ThisWorkbook.FollowHyperLink does what you describe, is only one line and is certainly more simple

[awsmitty]

I am shaking my head. Sometimes you guys take something that has bothered me for days, weeks, and boil it down to something so simple. Overthinking is an understatement. I'm still kinda LOL

Your suggestion works perfectly! Many thanks

[Kyle123]

We've all been there, Glad you got it sorted