Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing Data From HTML Source into Excel using VBA
I am trying to parse some data from some HTML web pages using VBA for Excel
(2002) but cannot remember the function to open the web pages and assign the source info to a variable in VBA. Does anyone know how to do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Parsing Data From HTML Source into Excel using VBA
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate "http://www.yahoo.com" 'place your desired URL here IE.Visible = True 'if you want to see the browser window, but not necessary While IE.Busy DoEvents Wend x = IE.document.body.innerHTML IE.Quit 'now the HTML code BODY your looking for is in the variable x you will need to add a reference to the msinet.ocx before using Lynn S "Peter Dickson" wrote in message . .. I am trying to parse some data from some HTML web pages using VBA for Excel (2002) but cannot remember the function to open the web pages and assign the source info to a variable in VBA. Does anyone know how to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Not get cell to accept any format change! Source from html | Excel Worksheet Functions | |||
Excel 2K and parsing data | Excel Worksheet Functions | |||
parsing data into Excel | Excel Discussion (Misc queries) | |||
Excel & HTML Parsing | Excel Discussion (Misc queries) | |||
how to change path name of html source folder ? | Excel Worksheet Functions |