This is Driving Me Nuts
New Member
- Joined
- Nov 22, 2019
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Option Explicit
Sub ie_automated ()
Dim IE As InternetExplorer
Dim sURL As String
sURL = "goldprice.org/silver-price.html"
Set IE = New InternetExplorer
With IE
.Top = 373
.Left = 25
.Width = 1700
.Height = 600
.AddressBar = 0
.Toolbar = 0
.Visible = True
.Navigate sURL
'Application.Wait Now + TimeSerial(0, 0, 10)
Do Until Not .Busy And .ReadyState = 4
DoEvents
Loop
IE.Document.all("nd-fsc-icn nd-fsc-icn16 nd-fsc-icn-FullScreen-B").click
'nd-fsc-icn nd-fsc-icn16 nd-fsc-icn-FullScreen-B
'goldprice.org/silver-price.html
'IE.Document.all("nd-mnu-btn").Click
End With
Do Until Not IE.Busy
DoEvents
Loop
Set IE = Nothing
Err.Clear
End Sub
Sub ie_automated ()
Dim IE As InternetExplorer
Dim sURL As String
sURL = "goldprice.org/silver-price.html"
Set IE = New InternetExplorer
With IE
.Top = 373
.Left = 25
.Width = 1700
.Height = 600
.AddressBar = 0
.Toolbar = 0
.Visible = True
.Navigate sURL
'Application.Wait Now + TimeSerial(0, 0, 10)
Do Until Not .Busy And .ReadyState = 4
DoEvents
Loop
IE.Document.all("nd-fsc-icn nd-fsc-icn16 nd-fsc-icn-FullScreen-B").click
'nd-fsc-icn nd-fsc-icn16 nd-fsc-icn-FullScreen-B
'goldprice.org/silver-price.html
'IE.Document.all("nd-mnu-btn").Click
End With
Do Until Not IE.Busy
DoEvents
Loop
Set IE = Nothing
Err.Clear
End Sub