Excel Data Scraping Macro Script.
€30-250 EUR
Pagado a la entrega
Hi to all,
We are small trading company in need for a custom made excel macro script.
Nature of the script is scarping of certain data from predefined set of websites.
Initial requiremant is script working with one website and then (due to different html structure of these websites) this functionality should be expanded to other websites of interest.
This is in short the idea behind the macro.
We would be using some screenshots in order to properly define what we need.
----------------------------------------------------------------------------------------------------
We have excel file and in one of the colums we have list of keywords. These keywords vary in size and they are sometimes only numbers, sometimes they are alphanumerical etc... keywords represent certan models, types or serial numbers of various devices like washing machines, dryers, owens, refrigirators etc...
This keyword list is the input data for the script.
Screenshot1: [login to view URL]
* Macro should take the first keyword, navigate the the specific website (you have the website address on the screenshots) use the search function on the website and preform the search for the specific keyword.
Screenshot2: [login to view URL]
* If there are search results for the keyword it should take the the specific data P1 and write it
in the column P1.
Screenshot3: [login to view URL]
* Then it should click on that product in order to enter the product page and for the specific keyword used in this exmple (100226) this product page looks like :
Screenshot4: [login to view URL]
* Then script should take P2, P3 and P4 data from the page and import it to the excel file:
Screenshot5: [login to view URL]
Screenshot6: [login to view URL]
After this step macro takes the next keyword and repeats the process while all keywords are processed.
----------------------------------------------------------------------------------------------------
Specific cases:
1. If there are no search results for some of the keywords, data fields P1 to P4 are left blank.
2. If there are more then one search result (2nd keywords in the exapmple file "101360")
script goes throught out all of them and separate the data in the P1 to P4 fields by ( ; ).
Screenshot7: [login to view URL]
Screenshot8: [login to view URL]
Screenshot9: [login to view URL]
----------------------------------------------------------------------------------------------------
Number of the keywords and their shape (numerical, alphanumerical...) may vary.
Macro should be able to handle unlimited number of keywords but usually there wont be more then 50-100 entries processed in a single run.
This script should work with the website used in the example but it would be extended to do the same thing on other websites of interest in the future so should be left "open" for extension.
Sample file used in this discription is available for download.
If additional information is needed we are available.
Thank you
Dean
Nº del proyecto: #9541888
Sobre el proyecto
Adjudicado a:
Hello Ok I just checked the code of the site and it is an easy task. I have a lot of experience scraping data with VBA, you will not be disappointed. Every website has a different source code so I will have to writ Más
20 freelancers están ofertando un promedio de €120 por este trabajo
Hello I can get you a VBA Macro that does this job in the next 24 to 48 hours. Do let me know if you are interested Thanks
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready Más
I will only work for your good feedback with a minimal cost. Trying to build client base with quality works. You will be satisfied.
I did a lot of scraping and excel generation. this wuote is reasonable. new on site so not that many reviews yet
i will do it in less time and budget. i am new here to work. i am willing to do it. i am very hopefull to avail this chance to get my profile strong.
Hello sir, I am a professional writer and I have written about 200 articles to my us client last month. I will provide my past work samples if you agree. the work will be quality and without grammer mistakes. If you wa Más
Pozdrav, imao sam danas vremena, pa sam uradio tabelu koja ti je bila potrebna. Ako zelis mozemo da se dogovorimo i van freelancer sajta. Pozdrav, Milan
I have great amount of experience in building applications using excel macros. I have been working on excel macros for good bit of time. I'm confident that I can handle this project very well. If interested contact me Más
Zemljace! Mislim da mogu da uradim ovo sto ti hoces . Meni je potreban prvi pozitivan posao i mislim da mozemo da se dogovorimo oko cene. Pozdrav!