Hello,
I'm having a heck of a time trying figure out how to extract the data I'm needing. I'm rather new to VBA and trying to read / watch many scraping videos and I'm not getting the output I'm looking for.
Ultimately I would like to have a table pulled from a completed /sold search from ebay
The following URL has a pre-filtered search criteria (excluding the "XXXXX" which I want to pull from the value on Worksheets("Sheet1").Range("A1")
https://www.ebay.com/sch/i.html?_from=R40&_nkw="XXXXX"&_sacat=0&rt=nc&LH_Sold=1&LH_Complete=1&_ipg=200
Starting on Worksheets("Sheet1") Row 6 I would like each column to list the following (up through the 200 that are shown, if could cycle through the first 5 pages (1000) that would be an ultimate value add!)
Column A = Title of Item that was sold (I believe is labeled S_item_title)
Column B = Amount it was sold for (I believe is labeled S_item_price)
Column C = Total Bids (I believe is labeled S_item_bidCount)
Column D = Date Sold (I believe is labeled S_item_endeddate)
Column E = Date Sold (I believe is labeled S_item_logisticscost)
Many appreciations, I know I'm basically asking for to be written from scratch, I've tried to pick apart other examples and am having no luck applying to my needs.
Cheers-
I'm having a heck of a time trying figure out how to extract the data I'm needing. I'm rather new to VBA and trying to read / watch many scraping videos and I'm not getting the output I'm looking for.
Ultimately I would like to have a table pulled from a completed /sold search from ebay
The following URL has a pre-filtered search criteria (excluding the "XXXXX" which I want to pull from the value on Worksheets("Sheet1").Range("A1")
https://www.ebay.com/sch/i.html?_from=R40&_nkw="XXXXX"&_sacat=0&rt=nc&LH_Sold=1&LH_Complete=1&_ipg=200
Starting on Worksheets("Sheet1") Row 6 I would like each column to list the following (up through the 200 that are shown, if could cycle through the first 5 pages (1000) that would be an ultimate value add!)
Column A = Title of Item that was sold (I believe is labeled S_item_title)
Column B = Amount it was sold for (I believe is labeled S_item_price)
Column C = Total Bids (I believe is labeled S_item_bidCount)
Column D = Date Sold (I believe is labeled S_item_endeddate)
Column E = Date Sold (I believe is labeled S_item_logisticscost)
Many appreciations, I know I'm basically asking for to be written from scratch, I've tried to pick apart other examples and am having no luck applying to my needs.
Cheers-
Last edited: