Launch IE and scrap data from the web site

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
 
R

ryguy7272

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---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top