VBA or MACRO to take screen shot from Mainframe screen and paste into excel sheet

Originally Posted by Andy Pope

this article explains how to do the screen grab from excel.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=1075

Thank you Andy for your quick reply . But still I have one doubt, with this VBA code when I'm executing this code, it is opening new excel sheet evertytime and paste it there. I want to paste the screens shot in the same excel sheet which I have opened and at the desired cell.

Do you have any idea about this?

Thanks,
Chits