O
omsoft
I want to launch IE from Excel and then go to a specific link, get a bunch of
data and save it as an Excel or CSV file.
I have the code below. But the site has login info. Does someone know how I
supply the login info? Thanks much.
Set ieApp = CreateObject("InternetExplorer.application")
sUrl1 = "https://www.yahoo.com"
If ieApp Is Nothing Then
MsgBox ("Could not launch Internet Explorer. The process will now
exit.")
Exit Function
End If
ieApp.Visible = True
ieApp.navigate sUrl1
Do
DoEvents
Loop While ieApp.busy
data and save it as an Excel or CSV file.
I have the code below. But the site has login info. Does someone know how I
supply the login info? Thanks much.
Set ieApp = CreateObject("InternetExplorer.application")
sUrl1 = "https://www.yahoo.com"
If ieApp Is Nothing Then
MsgBox ("Could not launch Internet Explorer. The process will now
exit.")
Exit Function
End If
ieApp.Visible = True
ieApp.navigate sUrl1
Do
DoEvents
Loop While ieApp.busy