| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Querytables WebTables equivalent for InternetExplorer.Application.Document.all()="HTMLT able"
I would like to use InternetExplorer.Application.Document.all()
="HTMLTable" to retrieve tables on web pages, however I am interested in specific tables. With Querytables you could use .WebSelectionType = xlSpecifiedTables and .WebTables = "1,2" to designate which tables to retrieve. Anyway to do this with using the other method? I prefer to not use querytables as this loads the data into a spreadsheet, which I really do not need; I am trying to use excel to convert web page tables into a flatfile text file. I'd like to keep the data in memory. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move a document from "recent items" to "documents" | New Users to Excel | |||
| Retrieving info from "child" to a "parent" document | Excel Discussion (Misc queries) | |||
| Solution "Your changes could not be saved" "The document may be read-only or encrypted" | Excel Discussion (Misc queries) | |||
| CreateObject("InternetExplorer.Application") | Excel Programming | |||
| "Querytables.add" in a loop; result is insert in a new row each t | Excel Programming | |||
Threaded Mode
