Beginner help with opening webpages using IE as object

[richardcarter]

Am trying to learn how to open a webpage using Internet Explorer as an object (not hyperlink). I can see many 'beginners guides' on how to open a web page and fill out a form etc.. but none relating to just opening a web page!!!

This is all I am trying to do: When I click on a stock code in a cell (e.g TSCO.L), I would like Excel to display the webpage 'https://uk.finance.yahoo.com/q?s=TSCO.L' in an already open IE instance. If I then click on another cell such as 'SBRY.L' then the webpage should change accordingly. Any pointers would be appreciated, many thanks!

 

[John_w]

Use the Worksheet_SelectionChange event to handle the cell click. Loop through Shell.Windows to find the open IE instance, then navigate to the URL.

 

[richardcarter]

Many thanks... I tried to figure out what you meant by 'Shell.Windows' and found this webpage http://www.mrexcel.com/forum/excel-...pplications-macro-already-open-ie-window.html but the sample code given just throws up the error 'user defined type not defined' so maybe my Excel version 2010 isnt compatible with that code. I will stick to hyperlinks I think because this is way over my head!!

 

[Norie]

You need to goto Tools>References... and add the reference(s) that are mentioned at the start of code ZVI posted.s

 

[richardcarter]

Thanks - I will try to figure out how to add that reference code... but before I spend another 4 hours trying to figure out which part of the code it is, does it mean that if I email the file to a colleague, they will also have to add the reference code on their PC or will it be embedded in the file? Thanks

 

[Norie]

It should be embedded in the file.

PS You'll easily find the required reference if you goto Tools>References... in the VBA. Once you've found it all you need to do is check it, no need to add further code.

 

[richardcarter]

Thanks for your help Norie, I figured that out... But now Im totally confused because I was on the understanding that the IE object model doesnt work with Firefox (my default browser), but when I ran the code it opened the webpage in Firefox...

 

[Norie]

Which browser is your default?