Launch IE and scrap data from the web site

  • Thread starter Thread starter omsoft
  • Start date Start date
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
 
IO don't see any login box there, or input box, or anything. Can you provide
the actual link and a little more information about what you want to do?

Thanks,
Ryan---
 
Back
Top