+ Reply to Thread
Results 1 to 3 of 3

Extract URL inside a <a href> tag from a webpage

  1. #1
    Registered User
    Join Date
    03-24-2013
    Location
    Quezon City, Philippines
    MS-Off Ver
    Excel 2010/2013
    Posts
    83

    Extract URL inside a <a href> tag from a webpage

    Dear all:

    I'm having a hard time in adjusting my code because at first it is working. After some time in adjusting and manipulating I got the error "Automation Error" "Unspecified Error" "The interface is unknown".. I'm not sure why I have arrived with this error.

    Also I would like to loop the code to get the URLs inside the folders of the said link, http://ows.doleta.gov/press/ and put all the links in one worksheet.

    Please Login or Register  to view this content.

    Your help is much appreciated!

  2. #2
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    It varies ...
    MS-Off Ver
    Office365 - 64bit
    Posts
    862

    Re: Extract URL inside a <a href> tag from a webpage

    I didn't get those errors but the code did get stuck in the waiting loop. Try this small change to your code:
    Please Login or Register  to view this content.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top right of thread.

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Extract URL inside a <a href> tag from a webpage

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. Formula to Extract URL & Text from Href Tag
    By newbieexceldude in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 12-17-2016, 10:02 PM
  2. [SOLVED] Load webpage on TOPMAN website, extract prices from webpage into Spreadsheet
    By AKK9 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-04-2013, 11:49 AM
  3. Excel 2007 : Data Extract from Webpage to Excel
    By Rob_Shah in forum Excel General
    Replies: 0
    Last Post: 03-03-2012, 08:15 PM
  4. Creating Dynamic Database to Webpage - Details Inside
    By cjm2010 in forum Excel General
    Replies: 0
    Last Post: 02-20-2012, 03:38 PM
  5. Macro to extract data from webpage
    By Bradley_99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-19-2011, 01:18 PM
  6. Extract database from webpage
    By Bru86 in forum Excel General
    Replies: 0
    Last Post: 08-04-2008, 10:01 AM
  7. extract data from webpage
    By zzseason in forum Excel General
    Replies: 5
    Last Post: 02-28-2008, 03:02 AM

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