Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I want to run a web query from Excel that retreives the raw HTML code, not the parsed HTML page. Specifically, instead of retreiving text from the page, I want to return the page's HTML title (read: the text that falls between the <title tags). Unfortunately, the web query interface only lets you pick page content. I recorded the web query process and tried hacking the VBA by hand, but it doesn't appear that there are any objects/parameters/commands that allow me to import the page as pure source code. Does anyone know how to trick the web query into loading the source code into worksheet? If so, I can then write some VBA to strip the <title value out for me. Any gurus out there have an answer? Thanks in advance- Jon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to import html file in excel 2007 | Excel Discussion (Misc queries) | |||
HTML TAGS that format Data for import into Excel | Excel Programming | |||
Import HTML reports into Excel with page formatting options | Excel Programming | |||
Parsing Data From HTML Source into Excel using VBA | Excel Programming | |||
Calling HTML Source code from within VBA for Excel | Excel Programming |