Extract prices from web page using excel list with product numbers


I have an excel sheet with a list of 150 SKU product numbers, i would like to retrieve the prices for each product number from this web site on a weekly base. the site url is [url removed, login to view]

an example of the query would be [url removed, login to view]

the product number in this case is 5200124320014

when the page loads you will see the lowest price situated under the image on the left hand side in a euro symbol ( 15,20 )

I want that price to be saved next to the product number in the excel sheet.


below is partially correct code can you tell me how much you would charge me to fix it

Private Sub Worksheet_Change(ByVal Target As Range)

If [url removed, login to view] = Range("keyphrase").Row And _

[url removed, login to view] = Range("keyphrase").Column Then

Dim IE As New InternetExplorer

[url removed, login to view] = True

[url removed, login to view] "[url removed, login to view]"; & Range("keyphrase").Value



Loop Until [url removed, login to view] = READYSTATE_COMPLETE

Dim Doc As HTMLDocument

Set Doc = [url removed, login to view]

Dim sPrice As String

sPrice = Trim([url removed, login to view]("price").innerText)

MsgBox sPrice

End If

Taidot: tiedonsyöttö, Excel, PHP, tietojärjestelmäarkkitehtuuri, Tietojen kaavinta verkosta

Näytä lisää: extract data web page using java, javascript ajax extract web page table excel, extract data web page excel vb, extract data web page using, program extract data web page excel, crawler extract data web page using php, extract href web page excel, excel 2007 extract data web page, excel extract data web page, save web page using excel, excel vba extract data web page, extract web page text excel, extract info web page using, download web page using excel vba, free extract data web page excel

Tietoa työnantajasta:
( 1 arvostelu ) Piraeus, Greece

Projektin tunnus: #16049884

Myönnetty käyttäjälle:


sure i can create a code for u or fix this code in 55 euros Relevant Skills and Experience sure i can create a code for u or fix this code in 55 euros Proposed Milestones €55 EUR - sure i can create a code for u or f Lisää

53 € EUR 1 päivässä
(401 arvostelua)

33 freelanceria on tarjonnut keskimäärin 110 € tähän työhön


Hi sir, I am scraping expert, I have did more than 350+ scraping project, please check my feedback then you will know. Can we discuss more details about this project? then I will provide example data/script Lisää

109 € EUR 3 päivässä
(350 arvostelua)

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. Relevant Skills and Experience Data Entry, Excel, PHP, Software Architecture, Web Scraping Propos Lisää

100 € EUR 3 päivässä
(292 arvostelua)

I can create simple desktop app that will read list of SKUs from you file and for each SKU it will get price and update Excel file just like you want. You can place it to Windows Scheduler. Relevant Skills and Experi Lisää

60 € EUR 1 päivässä
(449 arvostelua)

I have much experience in web scrapping My previous target was eCommerce web site. I fetch price, product image, name, category etc. I have solution to overcome ip block, catpcha and session. Relevant Skills and Exper Lisää

155 € EUR 3 päivässä
(38 arvostelua)

Hello gyamanis I have gone through your project Extract prices from web page using excel list with product numbers here we are for providing you the best service with my expertise in Data Entry, Excel, PHP, Softwa Lisää

175 € EUR 4 päivässä
(39 arvostelua)

Greetings Based on your requirement we have created few samples , please reply to my bid so that i can show you the quality work Looking forward to your reply Thanks Brad Relevant Skills and Experience Data collec Lisää

61 € EUR 1 päivässä
(284 arvostelua)

Hello Sir, I am an excel expert. I can help you with this project. Please open chat to discuss more about this project. Thanks Aanvik Relevant Skills and Experience Excel Proposed Milestones €155 EUR - Milestone

155 € EUR 3 päivässä
(43 arvostelua)

Hi, I am a highly trained on Data Entry ,Data Analysis, Research, Web search, Web scraping, Python, Expert with great knowledge of Word, Excel and PDF. Relevant Skills and Experience Data Entry, Excel, Python, Softwa Lisää

150 € EUR 3 päivässä
(138 arvostelua)

Ready to EXTRACT Prices from WEB PAGE very FAST..Send me your 150 SKU and lets START Relevant Skills and Experience Highly Expert and Experienced in price extracting ... I can fix your code as well Proposed Milestone Lisää

50 € EUR 2 päivässä
(174 arvostelua)

Hello, I'm quiet good in data scraping. Link to a presentation file from one of my previous work, you can take a look how it works. Regards. [url removed, login to view] Relevant Skills Lisää

100 € EUR 2 päivässä
(98 arvostelua)

Dear Employer, I will give you as much data as many as you want from [url removed, login to view] Please check my reviews and request you to give me a chance. Thanks!! Relevant Skills and Experience Web scraping Proposed Lisää

155 € EUR 3 päivässä
(52 arvostelua)

i am WebScrapping, WebCrawler expert and have full experience for 7 years. C#, .Net is my top skill and my interested skill. I can provide most quality and high fast. Relevant Skills and Experience C#, .Net Proposed Lisää

155 € EUR 3 päivässä
(17 arvostelua)

Hello sir, We have check detail as per that you need get price from website using sku number. we will do it now. Relevant Skills and Experience PHP Proposed Milestones €70 EUR - we will discuss later

50 € EUR 0 päivässä
(82 arvostelua)

Dear,[url removed, login to view] you for reviewing me. I have just read your project description carefully. I am suitable for this work and have enough power . I will provide the best product to you as you wanted. Relevant Skills and Lisää

222 € EUR 3 päivässä
(26 arvostelua)

Greetings of the day! Thank you for posting the job. Have gone through your requirements and would like to work on this. Relevant Skills and Experience I would like to update you that I have been working on the simil Lisää

100 € EUR 0 päivässä
(11 arvostelua)

Greetings. I'm a scraping expert with superb problme solving skill.. I've studied your requirements and code and feel quite confident. I can fix your code perfectly at 100$ within a day. Relevant Skills and Experience Lisää

77 € EUR 1 päivässä
(25 arvostelua)

Over 8 +years experience writing almost exclusively web scraping code. I've done it all. I can scrape all LinkedIn profile My languages in order of experience and use is Python, JavaScript, PHP. Python libraries ( sele Lisää

100 € EUR 3 päivässä
(9 arvostelua)

. Relevant Skills and Experience . Proposed Milestones €155 EUR - .

155 € EUR 3 päivässä
(15 arvostelua)

Dear client , hope you doing well . i 've gone through your requirement . i'm designer , developer and Blog Writer having experience of more than 5 year . want to take interest in your project . Relevant Skills and E Lisää

30 € EUR 1 päivässä
(16 arvostelua)

Hey there! I have read your description and checked the website. I can build a software for you using python through which you can get data into excel with one click. Please ping me for more details Relevant Skills a Lisää

50 € EUR 1 päivässä
(4 arvostelua)