+ Reply to Thread
Results 1 to 2 of 2

Extracting HTML from URL's VIA VBA/'MACRO

  1. #1
    Registered User
    Join Date
    09-22-2011
    Location
    nyc
    MS-Off Ver
    Excel 2003
    Posts
    4

    Wink Extracting HTML from URL's VIA VBA/'MACRO

    I have a simple request (I think...)

    I have a list of url's in column A.
    Columns B, C, D, E, F - is where I'll be looking to fill with extracted data.

    I need a macro that will go through each URL from column A , and then look through the HTML Source View and I want to extract certain html code.
    For example I want to extract anything between an <H1>H1 tags</H1>.

    My task requires me to just go to a website, and copy and paste the values that are in the same spot.
    So I'll have to copy the title tags and some extra text found in the very same spots.

    There are more than 300 urls and this is going to be a waste of my time.

    I'll need to be able to easily modify the variables in case I need to extract something else.

    VBA/Macro solutions welcome (even formulas if possible)

    I would appreciate this alot !

    Thank You
    Last edited by kmpoaquests; 04-29-2013 at 12:53 PM.

  2. #2
    Registered User
    Join Date
    09-22-2011
    Location
    nyc
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Extracting HTML from URL's VIA VBA/'MACRO

    bump .... wondering if this is even possible

    appreciate it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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