Re: Is there a way to extract data from an internet webpage using VB in Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: JulieD (JulieD_at_hctsReMoVeThIs.net.au)
Date: 02/22/05 

Date: Wed, 23 Feb 2005 00:10:57 +0800

Hi Douglas

have you checked out
data / get external data / new web query

the functionality of this is slightly different depending on your version -
so if you'ld like additional assistance please let us know what version of
excel you're using.

Cheers
JulieD

"Douglas" <dougsdir24@yahoo.com> wrote in message
news:befb84ec.0502220755.a4823e0@posting.google.com...
> Id like to extract some data from a table on a page on the internet
> when the user clicks a button a spreadsheet.
> I could write the code that examines the html and extracts the data
> myself , but is there a VB routine that i can load the html document
> into memory so i can search through it to extract the data
>
> The webpage is just a plain html document with a table 1/2 way through
> with the information in it i want.
>
> Douglas

Relevant Pages

  • RE: AxWebBrowser script code calling host C# method
    ... a function can be called from within the html document, ... I need to extend the functionality of the control such that a the html/Dhtml ... I want to be able to create a web page for this browser which ... I have the web browser application ...
    (microsoft.public.dotnet.framework.interop)
  • Re: How to call an object method named in a string variable ???
    ... GetMethod that takes BindingFlags parameter. ... > methods depending on data extracted from a database table. ... > For example if I extract value X from the database table I also extract a ...
    (microsoft.public.dotnet.languages.csharp)
  • Better way to extract string?
    ... I recently needed to extract the text in an HTML document that is contained ... string_chars(``, EBodyChars), ... append(Left1, Right, RightOfBodyChars). ...
    (comp.lang.prolog)
  • Re: Is there a way to extract data from an internet webpage using VB in Excel
    ... Microsoft MVP - Excel ... > Id like to extract some data from a table on a page on the internet ... > The webpage is just a plain html document with a table 1/2 way through ...
    (microsoft.public.excel)
  • Re: Separate Numeric and Text data
    ... >14 Martin Place ... any formula using number conversion ... would extract 123E14. ... this functionality would vary by locale. ...
    (microsoft.public.excel.worksheet.functions)