+ Reply to Thread
Results 1 to 1 of 1

[Automation] Get each Product Info from specified section.

  1. #1
    Forum Contributor
    Join Date
    04-13-2017
    Location
    Buchares
    MS-Off Ver
    2016
    Posts
    117

    Exclamation [Automation] Get each Product Info from specified section.

    Hey guys, I'm having some problems regarding the setup of an automation data extraction.

    I will try to explain in the best possible way, if not enough info is offered i will edit the main post as requested in order to clear the goal.

    The main goal : From a website with N sections, to select one (by me). The selected section has Y items on Z pages.
    Questions :


    The website is : https://xyz.como/supermarket/supermarket
    For this example i will choose the first section : //xyz.com/supermarket/bio/#1
    There are more than 8 pages with products.

    1) How i can access each item (Y) from each Page (z) and how do i know how to stop?

    2) From the items i will download the Picture, extract the name , price and some values from the second tab.The problem is :
    From the second available tab named : "Products", i retrieve every info as a full sentence. How i can retrieve each data as a table like presented in the website table?


    The main goal is for each item to create a new Sheet, doesn't matter the name Sheet(n) with the following data:


    Thank you for your time,
    I've attached the file in order to see the progress.
    Last edited by alexgoaga; 03-28-2019 at 08:59 AM.

+ 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. Print Product Info of Multiple Selected Products
    By basfaarts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2017, 01:33 AM
  2. Print Product Info of Multiple Selected Products
    By basfaarts in forum Excel General
    Replies: 2
    Last Post: 01-22-2017, 06:57 AM
  3. Replies: 1
    Last Post: 06-16-2013, 07:36 AM
  4. Deleting Row Section without Disrupting Formula Range Outside of Deleted Section
    By JeffNYG23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-14-2013, 09:10 AM
  5. Moving section headings from below section to above section..
    By Fayebaline in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-24-2011, 06:58 AM
  6. Replies: 4
    Last Post: 09-30-2009, 06:11 AM
  7. move that Row From the Waiting section to the completed section automaticly
    By jjsaw5 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-21-2007, 06:50 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