Opening Website in Different Browsers using Macro

[Dheepak]

Hi All,

I would like to ask your help to resolve my query. Is it possible to open the websites in different browsers using macro code?

Example:

I have the heading as MrExcel.com and three buttons named as below:

First Button: Open Website Using Internet Explorer
Second Button: Open Website Using Mozila Firefox
Third Button: Open Website Using Google Chrome

When i click the button "Open Website Using Internet Explorer" the web address "http://www.mrexcel.com/forum/forum.php" needs to open in Internet Explorer.

When i click the button "Open Website Using Mozila Firefox" the web address "http://www.mrexcel.com/forum/forum.php" needs to open in Mozila Firefox.

When i click the button "Open Website Using Google Chrome" the website "http://www.mrexcel.com/forum/forum.php" needs to open in Google Chrome.

can anyone please help on this? and also if the selected browser is not installed on the system, then it should popup a message box saying "The Select browser is not installed in your system!! Kindly install it and then select or select different Browser"

Thanks much in Advance!!

Regards,
Dheepak

 

[Gopalakrishnan]

Hi Dheepak,

I know code to open the site in IE which I already got in early this year, as below:

Private Sub CommandButton1_Click()
Dim o As Object
Set o = CreateObject("InternetExplorer.Application")
o.navigate "http://www.google.com/"
o.Visible = True
Set o = Nothing
End Sub

But I didn't try for other browsers, even I've spent a few time to search and get the appropriate code. But couldn't get, but still you could use the above code to open the target websites in different tabs using separate buttons like CommandButton2, CommandButton3,... and so on.

May be some other Expert could help us to fulfill your exact scenario.