+ Reply to Thread
Results 1 to 1 of 1

VBA code to extract data from multiple webpages to excel

  1. #1
    Registered User
    Join Date
    02-09-2014
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    VBA code to extract data from multiple webpages to excel

    Hello Everyone,

    I'm new to the forum and also very new to Excel VBA. I'm trying to scrape some data from website:
    http://www.thegreenbook.com/

    I want to extract Data in excel as Column A Industry, Column B Sub industry Column C Name and Column D Phone Number from call now tab from all the industries on the webpage

    on first page all industry tabs are there

    if i click on one of the tab it takes me to su bindustry tabs
    I want to import basic data list from all the sub industries and from all the pages
    I want to extract Data in excel as "Column A" Industry, "Column B" Sub industry "Column C" Name and "Column D" Phone Number from all the industries on the all the pages
    Example
    Architect (industry)
    Abrasive Cutting Wheels(Sub industry)
    then it will have number of pages
    i want data from basic listing from all the pages into excel in format i attached herewith
    Looking forward to get quick solution as i need this urgently

    Regards,
    Satish Phalke
    Attached Files Attached Files

+ 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. Extract a Specific data from multiple webpages to excel
    By pari9485 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-04-2013, 01:10 PM
  2. Getting data from multiple webpages into excel
    By missbg in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2013, 12:40 PM
  3. Getting data from multiple webpages and posting into one excel sheet
    By Ashima93 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 06-19-2013, 08:31 AM
  4. Scraping Data from tables in multiple webpages
    By heiyan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-21-2013, 10:35 AM
  5. Excel data overlaying on webpages
    By krush1972 in forum Excel General
    Replies: 0
    Last Post: 04-27-2005, 02:40 PM

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