GetPrintScreenSheetName() which will set global variables that assign the Destination WorkBook and Sheet Names. DeleteAllShapesOnPrintScreenSheet() which will clear the cells in the Destination Sheet and remove all shapes (images) from the Destination sheet.ī. Without Andy's help this wouldn't have been possible Ī. Thanks to Andy Pope (post #5 in the following thread). The file was successfully tested using Excel 2003 on a Vista 32 bit system, and on 32 bit Excel 2010 using Windows 8.1. See the attached file which implements 'Alt PrintScreen' (with an option for PrintScreen only).

Thanks once again for your assistance and Have a nice day!

Note: I do not have admin privileges at my workplace. xla was getting an invalid file error message I am really looking for the macro.infact I am attaching the same here, but it is not compatible with Office 2010 version and on starting leads to an error 'Compile Error in hidden module: modAddin and further'Īny help in activating this macro version for Office 2010, would be greatly appreciated. Switching between Onenote and the application being tested, is time consuming.not considering the additional effort for Pressing Insert and selecting Screen clipping. Onenote, if I understand correctly.works on the premise of manually selecting an area of the screen and the same gets captured. On account of manual testing, need to take about 100 screenshots, in a single day and if I consider my whole team.of 15 people, that is massive number. I have tried Onenote, while it does serve the purpose, it is not convenient. Firstly - Thanks a lot for replying, appreciate you taking your time out.

Screenshot microsoft excel 2007