Despite the fact that it is a very old issue, practicing is the best way to remember a hint. And the hint is, opening a web page through VBA code. Take a look at code below:
Private Sub OpenPage()
Dim browser As Variant
Set browser = CreateObject(“InternetExplorer.Application”)
browser.Navigate (“www.google.com”)
browser.Visible = True
End Sub |
Private Sub OpenPage()
Dim browser As Variant
Set browser = CreateObject(“InternetExplorer.Application”)
browser.Navigate (“www.google.com”)
browser.Visible = True
End Sub
So far so good, but the best thing in the code above is, the Internet Explorer is under your control! You can have access to all webpage data through the Internet Explorer object’s properties. Of course, you can play a bit with some simple properties, like:
Private Sub DrawingIn_Click()
Dim browser As Variant
Set browser = CreateObject(“InternetExplorer.Application”)
browser.Navigate (“www.google.com”)
browser.StatusBar = False
browser.Toolbar = False
browser.Visible = True
browser.Resizable = False
browser.AddressBar = False
End Sub |
Private Sub DrawingIn_Click()
Dim browser As Variant
Set browser = CreateObject(“InternetExplorer.Application”)
browser.Navigate (“www.google.com”)
browser.StatusBar = False
browser.Toolbar = False
browser.Visible = True
browser.Resizable = False
browser.AddressBar = False
End Sub
Enjoy!