Design a VBA macro
$30-250 USD
Πληρώθηκε κατά την παράδοση
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.
Ταυτότητα Εργασίας: #9040512
Σχετικά με την εργασία
Ανατέθηκε στον:
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 Περισσότερα
18 freelancers κάνουν προσφορές κατά μέσο όρο $160 για αυτή τη δουλειά
I am an expert in delivering custom software and scripts willing to discuss further about the requirements asap
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
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 Περισσότερα
I have the expertise in scripting in VBA and can implement the requirements as you have described. Ready to start work immediately
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 Περισσότερα
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 Περισσότερα
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, Περισσότερα
