In Progress

xls web query data scraping solution

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,

Skills: Excel, Visual Basic, Web Scraping

See more: web scraping with vba, web scraping solutions, web scraping solution, web data scraping freelancer, web build freelancer, vba freelancer excel, target solutions, online web solutions, objective of a freelancer, freelancer worksheet, freelancer web online, freelancer solution, freelancer scraping, freelancer pics, freelancer in visual basic, freelancer for excel macro, freelancer excel below $10, freelancer build a webpage, forums excel, excel visual basic freelancer, excel macro build freelancer, data capture solutions, data capture online other, concept web solutions, concept idea freelancer

About the Employer:
( 2 reviews ) Toronto, Canada

Project ID: #4248692

Awarded to:

Sudris

Hi, experienced VBA developer here. PM has detailed information, pls check it. thanks

$120 USD in 1 day
(1 Review)
2.2

15 freelancers are bidding on average $96 for this job

mantislin

Hi sir, please check PM, thx Kimi.

$250 USD in 5 days
(76 Reviews)
6.1
ZeusMan

Looking forward to working with you...

$75 USD in 1 day
(64 Reviews)
5.8
mrbrave

Please send me weblink to review....I have also added saple of my past work in message box.

$40 USD in 1 day
(74 Reviews)
5.4
mostacholoco

Hi, I can start right away. Please, check your PMB. Thanks. #### 5-start freelancer + 100% completion rate = 100% client satisfaction ####

$120 USD in 2 days
(12 Reviews)
5.1
tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT/ Data Entry/ Web Research/Admin/SEO/ Co More

$100 USD in 3 days
(9 Reviews)
4.8
raul27868

Hello, I can do this work for you and I'm ready to start. Please see pmb for more details. Regards Raul

$150 USD in 10 days
(10 Reviews)
4.5
nayabsiddiqi

Hello Can you provide you quick and reliable solution

$200 USD in 2 days
(7 Reviews)
3.8
ksnrajesh912

Hi please check PM

$60 USD in 2 days
(4 Reviews)
2.8
pratik30ei

hi sir ready to start your work

$50 USD in 2 days
(1 Review)
1.5
mfumia

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 you More

$90 USD in 2 days
(0 Reviews)
0.7
salih0vicx

Hi, I can do this. Looking forward to working with you :-)

$49 USD in 5 days
(0 Reviews)
0.0
manojsomanath

Excel VBA expert here. New to freelancer though. Pretty easy job for me and can do within a day.

$45 USD in 1 day
(0 Reviews)
0.0
auxigen

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 wha More

$50 USD in 1 day
(0 Reviews)
0.0
Raffyememon

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

$35 USD in 1 day
(0 Reviews)
0.0