Hello,

In work, we do have to perform searches on specific entities using Google, and screenshots of first page results have to be placed in specific areas of our excel files.
Macro to automatically perform searches is already completed. It will take required keywords from Excel Table, and open new Chrome Tab for each search variant.
For one entity two different searches are performed all the time. For Example: Entity Name : Google
Search1: "Google" United States. Search2: "Google" Email
Therefore 1 specific cell will contain 2 different screenshots all the time( or one, if Chrome tabs are split in 2 using Tab Resizer)

At the moment we are looking how to automate that screenshot task.
Macro should be able to browse through Google Chrome tabs, make screenshot and place it in specific area of Worksheet.

Made the start of code working using Virtual Key Codes, excel vba will send press PrtScn or any other required button when needed.

Issues that I am facing at the moment:
1. When I want to make 1 screenshot, of two searches performed on one entity, I have to split screen, I Managed to automate the part of splitting screen in two parts, however I got stuck on part when It has to take a picture, as print screen will either take a screenshot of all monitors ( we are using 3 all the time) if pressed just PrtScn. Or it will take a screenshot just of active windowALT+PrtScn, but this do not work, after spliting Chrome tabs, I do have 2 Chrome Windows in on monitor , somewhere I read that CTRL+ALT+PrtScn should take a screenshot only of active monitor, but that do not work in my case. Is there are any solution to this ? How to make screenshot just of one monitor?
2. Chrome is our default browser, and we are using all the time, sadly, Excel VBA do not have any default libraries to control it ( or I do not know about them yet), in addition to this, I cannot set loops to till all pages will load up, therefore I have to make a pause of specific amount of time. But sometimes it is enough 2sec for all screens to load up, and sometimes 8 seconds is not enough. And of course, If site is not loaded properly I am getting screenshots of blank windows ( which is not usefull). Any suggestions what to do with it. without installing 3rd part libraries like Selenium ?
3. Is there are any way, to run this task in a background and perform it faster?

Thank you!