Macro take multiple screenshots and save in excel

[krishnasree]

I am looking for a macro that can take screenshots whenever needed (only the screens that we require) and can save them to an excel sheet once done with taking all those screenshots.


Example: I have opened a website and want to take a screenprint of login page and payment page alone and save them in an excel document

[xman2000]

Hi Krishnasree!

not dificult!
works fine for me:

Cheers!

''http://word.mvps.org/faqs/macrosvba/PrtSc.htm"
"http://officetricks.com/print-screen-save-as-image-file-attach-to-sheet-automate-in-vba/"

[krishnasree]

I am trying to run that code but unable to derive proper result. Is there a way where we can add 3 buttons to the code (for start, taking screenshots and end) so that whenever we click on start, the macro will start running and when we click on the 2nd button, it will take the screenshot of that screen (we can click it 'n' number of times and each time we click it, it will take a screenshot of that screen) and once done with taking all the screenshots, if we click on 'end'(3rd button) it will stop taking screenshots and save it in an excel document.

[xman2000]

hi Hi Krishnasree!

iam not know mutch vba!
one shot solution!
attached sample file with (big buttons):

1 way save picture in worksheet
2 way save picture in hard disk and atatch it in the worksheet as linked icon

iam not able to iprove it.
good luck!
cheers!

15964