Write a code in VBA for custom website scrapping

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I pull out data from a website quite frequently and want to automate the process. I want to write a code in Excel VBA. The code will

1) pick up the input parameters from the excel sheet

2) go to the website, paste the parameters there

3) Data will appear

4) Copy the data and paste it in Excel

5) Make a graph of the data

6) go to the next row of input parameters and repeat

The input parameters will be in a table in Excel

Go to a website

<loop>

Enter credentials

*Data will pop up*

Copy the data, paste into excel, make plot

New Sheet

<loop end>

Excel PHP Visual Basic Visual Basic for Apps Web Scraping

Project ID: #15860795

About the project

11 proposals Remote project Active 6 years ago

11 freelancers are bidding on average $50 for this job

jaylancer43

Hello, My name is Jay and I am Excel and Web Scrapping Expert on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story). More

$100 USD in 1 day
(539 Reviews)
8.1
cgullapalli

HI, I am good at Excel and VBA. Please share me the site details to scrape. I would like to check the scope of work. Looking forward to work on the project. I can make it automated as required. -Chandra

$34 USD in 1 day
(628 Reviews)
7.7
schoudhary1553

Hello Sir, I have read your project requirement and i can deliver your project with 100% quality . please give me chance to work on your job. I have more than 7 years of experience in Excel, PHP, Visual Basic, Vi More

$90 USD in 1 day
(223 Reviews)
7.3
elbruninh

is VBA mandatory? i can do it with PHP what is the website? can you send me a sample grapth? regards

$50 USD in 1 day
(78 Reviews)
6.3
vlayausa

Hello, I am proficient with Excel and VBA. I understand your project and would like to help. Please contact me for more information.

$35 USD in 1 day
(128 Reviews)
5.8
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat More

$53 USD in 2 days
(51 Reviews)
5.5
aubrey03

I can build this tool by using Excel and Selenium VBA which can manipulate Google Chrome. It will run faster than a tool built using plain VBA and Internet Explorer.

$30 USD in 1 day
(15 Reviews)
4.4
thuyduongrands

Dear Mardam or Sir, You need an accountant . I am the one you need . I have great experience working as an Accounting throughout my career. I have over 10 years of experience and knowledge of accounting and good skill More

$26 USD in 1 day
(7 Reviews)
3.5
vmadhavan15

I am not a random bidder... I hope I can do this one and I do not outsource the work.. Please ping me if you are interested with my proposal and thank you...

$83 USD in 1 day
(7 Reviews)
3.4
Jacopo1990

I spent a year and a half working as Excel and VBA programmer for a bank. I am looking for a first project here, a good review would be _very_ helpful for me :) At your disposal for any information. Jacopo

$21 USD in 1 day
(0 Reviews)
0.0