Open browser using VBA code

I currently use the code below to open a webpage through VBA code.  Instead of launching IE, I would rather use another browser like Chrome, Firefox or Opera.  I just want anything but IE.  
Thought I would be able to find a quick solution for this, but nothing yet.  Any ideas?  Thanks.


Public Sub fnShowPage()
Dim oIE As Object
Set oIE = CreateObject("InternetExplorer.Application")

oIE.navigate ("http://myaddress.com")
oIE.MenuBar = True
oIE.StatusBar = False
oIE.Resizable = False
oIE.addressbar = False
oIE.Toolbar = False
oIE.Visible = True

'maximize the IE window
Dim retval As Long
retval = ShowWindow(oIE.hWnd, SW_SHOWMAXIMIZED)

'wait for page to load before filling in the values
Do While oIE.busy
  DoEvents
Loop
 
End Sub
DanielAttardAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
If all you need to do is load a web page, this works for firefox:


Shell "c:\progra~1\mozill~1\firefox.exe -new-window www.google.com", vbMaximizedFocus

For other browsers, just figure out what the command line instructions are.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Psy053Commented:
As Matthewspatrick points out, you can use Shell to open other browsers, however, you will lose the automation functionality that comes with the InternetExplorer.Application object.

I noticed in your sample that you mention "filling in values" - this alone will be significantly more difficult when using alternate browsers as you're going to have to rely on SendKeys to move between fields, populate fields, and press buttons - troublesome at best, and then there's the added risk of focus being stolen from the browser, and the sendkey events being sent to the wrong place.
DanielAttardAuthor Commented:
Thanks for the help matthewspatrick.  Your solution did the trick.

Psy053 - You made a good point about losing the automation functionality that comes with with InternetExplorer.Application object.  Although my code made reference to "filling in values", in actual fact that code relates to something else.  For the present problem, I only needed to open the page and not fill in any values so that solution from matthewspatrick works fine.

Thanks again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.