View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Launch IE and scrap data from the web site

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

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"omsoft" wrote:

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