VBA Excel expert required to fix errors
Budget: ₹400 – ₹750 INR
VBA Excel expert required to fix errors in old code.
You will need to step through the code with me on my computer to possibly change website address where Information is scraped from or fix errors in regard to the existing address.
This Database has had several lives so there is lots of code in there that is no longer relevant so it could prove confusing without my input
There are several points that will need fixing
One of my scrapers is still working
I did not write the code and don't know how to write code but i can view it and have a vague understanding of it.
I believe that the webpages that i have scraped data from for many years has updated/modified something around 1 month ago (happens every few years)
I use Internet Explorer to scrape the data (this might be part of the problem).
I am in New Zealand and would prefer to work nights or weekends
will use Google Chrome Remote Desktop to share my screen.
one drive link below
HK Xlam
https://1drv.ms/f/c/32495299d2f56d4e/IgBoJEphE9v0QJSMVT3oab5pAX07kKLI9uHWm8mApgyGdgo?e=tBwWwJ
the pages below are where I scrape
https://racing.hkjc.com/en-us/local/information/localresults
https://racing.hkjc.com/en-us/local/information/btresult
https://racing.hkjc.com/en-us/local/page/new-horse
https://racing.hkjc.com/en-us/local/information/racecard
https://racing.hkjc.com/en-us/local/info/speedpro/speedguide?raceno=1
Thanks
You will need to step through the code with me on my computer to possibly change website address where Information is scraped from or fix errors in regard to the existing address.
This Database has had several lives so there is lots of code in there that is no longer relevant so it could prove confusing without my input
There are several points that will need fixing
One of my scrapers is still working
I did not write the code and don't know how to write code but i can view it and have a vague understanding of it.
I believe that the webpages that i have scraped data from for many years has updated/modified something around 1 month ago (happens every few years)
I use Internet Explorer to scrape the data (this might be part of the problem).
I am in New Zealand and would prefer to work nights or weekends
will use Google Chrome Remote Desktop to share my screen.
one drive link below
HK Xlam
https://1drv.ms/f/c/32495299d2f56d4e/IgBoJEphE9v0QJSMVT3oab5pAX07kKLI9uHWm8mApgyGdgo?e=tBwWwJ
the pages below are where I scrape
https://racing.hkjc.com/en-us/local/information/localresults
https://racing.hkjc.com/en-us/local/information/btresult
https://racing.hkjc.com/en-us/local/page/new-horse
https://racing.hkjc.com/en-us/local/information/racecard
https://racing.hkjc.com/en-us/local/info/speedpro/speedguide?raceno=1
Thanks
Related categories:
Excel
Web Scraping
HTML
Debugging
Regular Expressions
Excel VBA
Excel Macros
Data Scraping
Selenium Webdriver