Hi,
There is a requirement where we need an excel macro which captures the screen prints of the screen using keyboard combinations( lets say CTRL + D) and align those screen prints vertically one by one in the excel sheet itself.
The requirement is completely built i.e. macro is capturing screen prints and aligning it properly and paste it in the sheet. but currently we a facing an problem with the macro.
The problem is that the key combination (i.e. CTRL+D) does not work when the excel sheet is completely minimized.
Currently there is a limitation on the excel macro sheet is user needs keep the sheet open for capturing the screen prints and hence results in capturing excel sheet's prints as well in the screenshot.
I need to know what can i do to my code so that the key combination will work even when the sheet is completely minimized.
Thanks in advance.
Dimple
There is a requirement where we need an excel macro which captures the screen prints of the screen using keyboard combinations( lets say CTRL + D) and align those screen prints vertically one by one in the excel sheet itself.
The requirement is completely built i.e. macro is capturing screen prints and aligning it properly and paste it in the sheet. but currently we a facing an problem with the macro.
The problem is that the key combination (i.e. CTRL+D) does not work when the excel sheet is completely minimized.
Currently there is a limitation on the excel macro sheet is user needs keep the sheet open for capturing the screen prints and hence results in capturing excel sheet's prints as well in the screenshot.
I need to know what can i do to my code so that the key combination will work even when the sheet is completely minimized.
Thanks in advance.
Dimple