| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I import raw HTML source code into Excel?
..Document.Body.outerHTML Tim "got mike?" wrote in message ... okay, that works for the title, but i'm trying to parse the actual html to pick out data in the middle of the page. how would you alter this to search to just get the raw html code on the page? "Jake Marx" wrote: Hi Jon, Here's a function that should return the page title of an HTML document (or an empty string if URL is invalid or can't be found): Public Function gsGetURLTitle(rsURL As String) As String Dim ie As Object Set ie = CreateObject("InternetExplorer.Application") With ie .Navigate rsURL Do While .Busy And Not .ReadyState = 4 DoEvents Loop gsGetURLTitle = IIf(StrComp(.Document.Title, _ "Cannot find server", vbTextCompare) = 0, _ vbNullString, .Document.Title) .Quit End With Set ie = Nothing End Function -- Regards, Jake Marx MS MVP - Excel www.longhead.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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 | |||
Threaded Mode
