First of all, sorry for bringing an old thread back to live.
Chits asked the same question I'm having right now.

I'm working with IBM Mainframe applications and would like to create a macro (VBA) in Excel which takes a screenshot of the application window and paste it where the Excelbutton will be in place. Sort of 'replace button with screenshot'.

To be honest, I have no idea how I can start programming this. Also, the link Andy Pope posted a few post before does not work anymore :-(

Is there anyone who can help me achiving this?

Thanks in advance!