Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Molly Torres   on Feb 27 In MS Office Category.

  
Question Answered By: Rochelle Elliott   on Feb 27

I have done a little bit of programming to interphase with Excel and
Internet Explorer. I can give  you a start off on how to connect and read
I hope this will help you to carry on your further investigation.

Dim ie as Object

'Create an object to Internet Explorer
Set ie = CreateObject("InternetExplorer.Application")

path1 = "http://www.google.co.in/ <http://www.google.co.in/> "

ie.Visible = False
ie.Navigate (path1)

'Wait till explorer navigate's to the page
While (ie.Busy = True)
Wend

'All the text on the current window will be assigned to strdata variable
strdata = ie.Document.body.innertext

You can search for the data you are looking for from this strdata
variable. Hope this helps :)

Share: 

 

This Question has 2 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on HOW TO LINK EXCEL TO INTERNET Or get search suggestion and latest updates.


Tagged: