+ Reply to Thread
Results 1 to 1 of 1

Excel VBA To Find & Copy Specific HREF Link From Web Pages And Paste It In Excel

  1. #1
    Registered User
    Join Date
    03-27-2013
    Location
    NY, USA
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel VBA To Find & Copy Specific HREF Link From Web Pages And Paste It In Excel

    Hi,
    I am not a programmer and I need a VB code in excel 2003 to automate the following:

    1) Have 1000s of rows of web page URLs in Col A.
    2) Need code to connect to or go to each URL one by one (eg, http://www.walmart.com)
    3) After going to or connecting to an URL, search and copy specific HREF on the page (eg, Search for HREF "ABOUT", if not found, then search for HREF "ABOUT US", if not found then close connection to this URL and go to next URL).
    4) Paste copied HREF link to corresponding cell in Col B (eg, http://help.walmart.com/app/answers/detail/a_id/6). If no HREF was found, then leave cell blank.
    5) Repeat Steps 1) - 4) until last URL in Col A.
    6) If needed, put a time delay between URL disconnect and next URL connect.

    Will greatly appreciate any help

    sgoes
    Last edited by sgoesef; 09-29-2013 at 04:58 PM.

+ 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. Macro to copy specific line from text file and paste into specific cell in excel
    By keeneye in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-05-2013, 10:35 AM
  2. Excel: Find All (specific) Copy All, Paste All ?
    By coffee_king in forum Excel General
    Replies: 1
    Last Post: 09-19-2012, 02:15 PM
  3. Find a list of countries names, copy specific row and paste into new excel file.
    By alvin9 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2011, 12:16 AM
  4. Excel 2003 / Href and PDF link to Colum Count
    By rbvinc in forum Excel General
    Replies: 1
    Last Post: 01-18-2011, 10:39 AM
  5. [SOLVED] Help with Click link, Find, Paste (Excel to Web back to Excel)
    By Steve in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 04:06 PM

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