+ Reply to Thread
Results 1 to 9 of 9

Extract data from Page and subpages in Excel by vba

Hybrid View

fabiosp Extract data from Page and... 09-19-2014, 12:04 PM
Marc L Re: Extract data from Page... 09-19-2014, 12:16 PM
fabiosp Re: Extract data from Page... 09-22-2014, 04:21 AM
Marc L Re: Extract data from Page... 09-22-2014, 04:43 AM
fabiosp Re: Extract data from Page... 09-22-2014, 09:50 AM
Marc L Re: Extract data from Page... 09-22-2014, 11:12 AM
fabiosp Re: Extract data from Page... 09-22-2014, 06:30 PM
Marc L Re: Extract data from Page... 09-22-2014, 06:43 PM
fabiosp Re: Extract data from Page... 09-23-2014, 03:27 AM
  1. #1
    Registered User
    Join Date
    09-19-2014
    Location
    italy
    MS-Off Ver
    2007
    Posts
    5

    Extract data from Page and subpages in Excel by vba

    I use Excel 2010 and Vba.
    I have an url ( www.example.it )
    i'like to extract some data ( email addresses ) from this url.
    If url contains other links i'd like analyze them and extract data also from there.

    I hope to be sufficiently clear.
    Fabio.

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Extract data from Page and subpages in Excel by vba


    It depends on the real webpage ! So without a valid link, you are on your own !

    But there is a lot of samples everywhere on the Web, just search !

    Ciao !

  3. #3
    Registered User
    Join Date
    09-19-2014
    Location
    italy
    MS-Off Ver
    2007
    Posts
    5

    Re: Extract data from Page and subpages in Excel by vba

    I start from a web page and i'd like exctract all emails in that page and in the other links in that page.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Extract data from Page and subpages in Excel by vba


    Search on Web how to automate Internet Explorer or create XMLhttp request,
    how to extract data from Web like emails or links, so many examples !

  5. #5
    Registered User
    Join Date
    09-19-2014
    Location
    italy
    MS-Off Ver
    2007
    Posts
    5

    Re: Extract data from Page and subpages in Excel by vba

    I look for that but now i can just to extract data from my page and not from the subpages.
    Can u help me ?

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Extract data from Page and subpages in Excel by vba


    Like I already wrote in post #2 …

  7. #7
    Registered User
    Join Date
    09-19-2014
    Location
    italy
    MS-Off Ver
    2007
    Posts
    5

    Re: Extract data from Page and subpages in Excel by vba

    do you want an example ?
    you can go in this page
    http://www.bovolone.gov.it/servizi/M...t=4333&ID=4334

    Thank you
    Fabio

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: Extract data from Page and subpages in Excel by vba


    Can you detail exactly what you need ?

    And post your actual code which extracts data from page …
    Last edited by Marc L; 09-22-2014 at 06:47 PM.

  9. #9
    Registered User
    Join Date
    09-19-2014
    Location
    italy
    MS-Off Ver
    2007
    Posts
    5

    Re: Extract data from Page and subpages in Excel by vba

    In Excel , using Vba ,
    i'd like to extract all the email that are in that page and subpage.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  2. Extract Data from Web Page Source Code
    By R1chard in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 03-31-2014, 05:19 AM
  3. Extract Data from a Web Page - using VBA
    By Tejas.T in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-21-2012, 03:17 PM
  4. Replies: 0
    Last Post: 08-08-2012, 04:25 AM
  5. website (whole, not just one page) extract certain info to excel (links, titles..)
    By jtripp81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-19-2009, 03:10 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1