Here the code that can help you to easily open your website through VBA..
Sub VisitWebsite()
Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://excelmacrosnvba.blogspot.com"
ie.Visible = True
While ie.busy
DoEvents
Wend
End Sub
** Change the url..
Sub VisitWebsite()
Dim ie As Object
Set ie = CreateObject("INTERNETEXPLORER.APPLICATION")
ie.NAVIGATE "http://excelmacrosnvba.blogspot.com"
ie.Visible = True
While ie.busy
DoEvents
Wend
End Sub
** Change the url..
No comments:
Post a Comment