Design a VBA macro

In Progress Posted Dec 4, 2015 Paid on delivery

$30-250 USD

Paid on delivery

In Progress Paid on delivery

I am looking for a guy who can program the following VBA macro by using the selenium library:

- I have a list in which there are data in different rows.

- Please find sample data attached.

By clicking on an action button, the following happens:

1. A folder is created in the directory C:\Users\Florian\Desktop\Dokumentationen

name of folder: [column ID2 of excel file]

2. Open Google Chrome

- clear history and cache

- make screenshot of the cleared cache

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

3. Open the link of the column link_webseite in Google Chrome

- wait until page is completely loaded

- print the page as a PDF (important: the PDF needs to look exactly that way how it looks when printed via Google Chrome manually)

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

4. Open source text of the link of the column link_webseite in Google Chrome

- wait until page is completely loaded

- print the page as a PDF (important: the PDF needs to look exactly that way how it looks when printed via Google Chrome manually)

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

5. Search after the following string in [url removed, login to view]: site:[Link_webseite from excel file]

- make a screenshot of the site

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

6. Open the link of the column link_image in Google Chrome

- wait until page is completely loaded

- print the page as a PDF (important: the PDF needs to look exactly that way how it looks when printed via Google Chrome manually)

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

7. Open the link of the column link_image in Google Chrome

- wait until page is completely loaded

- make a screenshot of the site

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

8. Open [URL of the column]/[url removed, login to view] in Google Chrome

- wait until page is completely loaded

- print the page as a PDF (important: the PDF needs to look exactly that way how it looks when printed via Google Chrome manually)

- Save it in the directory: C:\Users\Florian\Desktop\Dokumentationen\[ID2 of excel file]\[ID of excel file][url removed, login to view]

Please just bid when you can realize with a VBA macro in combination with Selenium library and you can fulfill all the requirements.

Excel PHP Software Architecture Visual Basic

Project ID: #9040512

About the project

19 proposals Remote project Active Dec 8, 2015

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

nmcdorman

Hello, My name is Nathan. I am quite capable of delivering what you are asking for. I am an expert with VBA among many other languages. I understand Selenium's functionality and how it must integrate with Excel VBA to More

$150 USD in 2 days

(1 Review)

3.6

19 freelancers are bidding on average $160 for this job

srinichal

I am an expert in delivering custom software and scripts willing to discuss further about the requirements asap

$200 USD in 5 days

(174 Reviews)

7.5

fhasanbd

A proposal has not yet been provided

$155 USD in 3 days

(133 Reviews)

6.5

prashushinde9

I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably More

$257 USD in 10 days

(45 Reviews)

6.7

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am ser More

$147 USD in 3 days

(43 Reviews)

6.2

sonarkaushik

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 give reference of my online work portfolio once I heard from you. I am ve More

$155 USD in 3 days

(71 Reviews)

6.0

surekash7096

I have the expertise in scripting in VBA and can implement the requirements as you have described. Ready to start work immediately

$100 USD in 2 days

(31 Reviews)

4.4

atifarzi

selenium is used to create macros which are very limited in capabilities. I can build it using VBA excel file and Internet Explorer. Doing the same in Google Chrome is impossible even if you use selenium. Please consul More

$90 USD in 5 days

(12 Reviews)

3.5

Maheshpatel107

Hello, I have 3 years experience in VB,VBA and VB.NET,C# and JAVA development. I have worked with VB6.0 as Front-end VBA Script EXCEL VBA MS Access as Back-end (.mdb) FoxPro DBF as Back-end (.dbf) Crystal Repor More

$200 USD in 5 days

(3 Reviews)

2.9

gsanggara

Hello, I am interesting to your project & placed bid for your consideration. with my experiences in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Ap More

$150 USD in 3 days

(7 Reviews)

2.6

kjgroup197318

---------------------------------Nice job. I can do it. No problem. Master in VB,C#,C++----------------------

$250 USD in 3 days

(4 Reviews)

2.9

MinhLeNguyenAnh

Dear Sir/ Madam I'm a professional VBA, VB and C# developer. I have 7+ years of experience in MS OFFICE and 4+ years of experience in VBA, VB and C# development. If you want your job done professionally and on time, More

$133 USD in 3 days

(1 Review)

1.0

didiku0582

i have experience in create excel with VBA on my last project

$244 USD in 8 days

(0 Reviews)

0.0

joechung2010

HTML CSS,javascript,MS Office,Data Entry,Data Conversion from PDF to MS Word and MS Excel and internet research. Linux server, VMware, Computer hardware

$155 USD in 3 days

(0 Reviews)

0.0

petsfagtq

I am an honest, hardworking meticulous, conscientious, executive, hardworking, observant, quick, attentive, thoughtful, accurate, fair, impartial, objective, diligent, industrious, diligent, intelligent, observant, res More

$155 USD in 3 days

(0 Reviews)

0.0

khemiriridha2013

A proposal has not yet been provided

$155 USD in 3 days

(0 Reviews)

0.0

Post a project like this