+ Reply to Thread
Results 1 to 4 of 4

Data Extraction from Web

  1. #1
    Forum Contributor
    Join Date
    10-20-2005
    Posts
    130

    Data Extraction from Web

    Hi All,

    I have a link http://www.ec21.com I am looking to extract some specific information by clicking on each link to an excel file. I am aware of the technique called web scraping, but apart from that I am looking if there's any other technique to do the same. I will appreciate your thoughts on it. I need to reach this page n extract Contact information & only some part of company profile.

    About Web Scraper : I am taking tutorials for Velocityscape web scraper n I find it bit difficult if any one of you can suggest any other method using macro or something like that it will be great help.

    Thanks in advance for your suggestions/ help.

    Thanks and Regards,
    Little Master
    Regards,
    Little Master

  2. #2
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Data Extration from Web

    In the attachment I made use of a Webquery.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-20-2005
    Posts
    130

    Re: Data Extration from Web

    Thnx a ton snb. But how u did this ??I can't see any kind of VB coding... thnx in advance...

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Data Extraction from Web

    Like I said: Webquery:

    MenuBar/Data/external data/webquery

+ Reply to Thread

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