Need to scrape and save website table data that is constantly being updated online. Webpage is very simple (just table list with two txt columns) and requires no logins, contains no pics, no links, etc.
Target webpage is constantly updated and replaces old table date with new entries with each reload. We need to save and build a complete list of the posted website information (old data + updated data) on a ongoing basis.
A suggested approach may be using an xls web query (with refresh ~10min) to capture data into worksheet and then copy this with a Macro into a second sheet that stores and saves a list of the complete updated information while running. The idea is that each new refresh list of web query data automatically gets added and saved below the previous in the second xls worksheet.
Looking for a Freelancer who can provide this solution using xls concept above (or any other efficient method/program) to accomplish the objective. Have seen partial solutions and variations of this task online in excel forums, but we are not familiar enough with VBA to adapt the requirements for our purposes.
Thanks,
Greetings,
I am very interested in your project. I have significant Visual Basic development experience (including VBA) and I am confident I can deliver the solution you need.
I am available to begin work on your project immediately.
Thank you for considering my bid,
Matt
I am a professional VBA/Excel developer. I will have some time to complete your project this weekend. I also already have a similar project already created (for myself), so with a few tweaks, I can roll out exactly what you need.
Dear Employer,
I have 8+ experience with Microsoft excel and external data querieng. kindly update the weblink for review that would help understanding the nature of work.
Regards,
Raffye