+ Reply to Thread
Results 1 to 2 of 2

VB code to scrape a few things from a page

  1. #1
    Registered User
    Join Date
    06-25-2014
    Location
    Falkirk, Scotland
    MS-Off Ver
    Office Excel 2013
    Posts
    31

    VB code to scrape a few things from a page

    Hi folks,

    Could anyone help me here with some VB scripting, I have a table and in the first column is a list of URL's from the same website,
    Here is one of the links: http://www.customworks.co.uk/item/Br..._0_3624_0.html

    In column B I would like to pull the category "Magnets" (Found as a link right below the price),
    In column C I would like to pull the sub-category "Dandy" (Found as text below the product name),
    In column D I would like to pull the product name "I'll catch them mister" (Found at the top of the information area,
    In Column E I would like to pull the URL of the image "http://www.customworks.co.uk/shop/images/products/large/1380190441DandySQ4.jpg" for this page.

    Thanks for your time folks!

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Lightbulb Re: VB code to scrape a few things from a page


    Hi,

    start with this : Automate Internet Explorer

+ 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. Scrape Data Using VBA From IE to Excel - Help with code
    By Galleon in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-07-2014, 11:00 AM
  2. Screen Scrape Code
    By bpeyton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2013, 02:57 PM
  3. the things to consider when your vba code needs to switch from .xls to .csv files
    By intothewild in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2012, 06:27 PM
  4. Code to scrape system generated outlook email doesn't get all the data
    By bobaftt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-15-2010, 01:57 PM
  5. VBA to control web page and scrape data
    By CharlieSierra in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2008, 10:50 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