Design a VBA macro
$30-250 USD
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][login to view URL]
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][login to view URL]
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][login to view URL]
5. Search after the following string in [login to view URL]: 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][login to view URL]
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][login to view URL]
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][login to view URL]
8. Open [URL of the column]/[login to view URL] 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][login to view URL]
Please just bid when you can realize with a VBA macro in combination with Selenium library and you can fulfill all the requirements.
Project ID: #9040512
About the project
18 freelancers are bidding on average $160 for this job
I am an expert in delivering custom software and scripts willing to discuss further about the requirements asap
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
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
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
I have the expertise in scripting in VBA and can implement the requirements as you have described. Ready to start work immediately
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