Results 1 to 3 of 3

Extracting Specific Piece of Data From Web

Threaded View

  1. #1
    Registered User
    Join Date
    01-20-2009
    Location
    Tampa, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Extracting Specific Piece of Data From Web

    Hey,

    I've been trying to figure this out myself, but I haven't had too much luck. I'm not good with programming so that may be the problem!

    I'm trying to make a macro in Excel 2007 that will take a word from my spreadsheet, go to google, do a search in this format allinanchor:"keywordhere" and then pull only the number of search results from the results page and put that back into Excel.

    The exact URL for this is this...
    http://www.google.com/search?hl=en&q=allinanchor:"keyword+goes+here"&btnG=Search

    Could someone please help?

    I would like to record a macro that would go from row to row and do each keyword that I have. I would also like to put a pause in between each run.

    My main concern right now is simply getting the data from the website into excel. I can most likely figure out the other stuff later.

    I appreciate any help you guys can offer! Thanks!

    Regards,
    Adam Murray
    Last edited by AdamMurray; 01-21-2009 at 05:29 PM.

Thread Information

Users Browsing this Thread

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

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