
01-13-2004, 03:29 PM
|
Newcomer
|
|
Join Date: Jan 2004
Posts: 3
|
|
Open a website using VBA/Excel
Guys (Girls?),
I have found some code on this forum that works great to open a website from VBA, but since it does refer to Internet Explorer, I suppose it will not work if the user of my spreadsheet does have a different webbrowser on his/her computer than IE. Is there a universal way to open a website from within VBA with "the standard program associated with the .html file extention" or something?
The code I am referring to is:
Sub VisitWebsite()
Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://websiteaddress"
ie.Visible = True
While ie.busy
DoEvents
Wend
End Sub
|
|