De: Tom Ogilvy <twogilvy@email.msn.com>
Objet: Re: Getting date from an HTML file on the web
Date : dimanche 27 août 2000 19:33

You can just open it in Excel - then use find on the resulting
workbook/worksheet

A better way might be to use the internet explorer
Jake Marx posted this a while back

http://x59.deja.com/=dnc/getdoc.xp?AN=620703256

====================>
Another approach would be to automate Internet Explorer.  Below is a
function I created that will return the HTML source for a given URL.  You
could expand the function to look at certain frames, etc (look up the
Navigate method in MSDN Library for more options).  You may want to add some
error handling as well.

Regards,
Jake Marx


Public Function sGetHTML(rsURL As String) As String
    Dim objIE As Object

    set objIE = CreateObject("InternetExplorer.Application")

    With objIE
        .Navigate rsURL
        Do Until Not .Busy
            DoEvents
        Loop
        With .document
            If Not (.url Like "res*") Then sGetHTML _
             = .documentelement.innerhtml
        End With
        .Quit
    End With

    set objIE = Nothing
End Function

=====================>

Regards,
Tom Ogilvy
MVP Excel


codefighta <codefighta@techsoftdesign.com> wrote in message
news:39A95931.1182@techsoftdesign.com...
> Hello,
>
> How can I retrieve web page off the web and then search its source code
> for a specific string and grabs the entire text of the line it is
> contained in or just a specific part of it?
>
> I know you can get an html page with a web query, but it does not seem
> to display the page and not the source code.
>
> Thanks

 