vba to take a screen dump of an IE window already open

[cjcass]

Hi,
I'm looking for some code that will take a screen dump of an IE window that is already open and copy it to the clipboard. So, the code mimics me moving from Excel to the IE window (that is already open and maximised), doing a printscreen/copying the whole page, and then pasting it into the worksheet as a picture. It would be good if the code could reference the last IE window opened, if not possible then navigate to a specific opened URL, eg. http://www.google.com
Any help much appreciated.

 

[Jaafar Tribak]

Run Time Error 13 : Type Mismatch
IE 11

Try declaring the sngPrevZoom variable as String instead of as Single ( the varaible declaration is inside the main SaveIEToClipboard sub)

 

[cjcass]

Awesome!!
Works perfectly - thank you (all) for your time, very much appreciated

 

[Jaafar Tribak]

I am glad you got this sorted and thanks to John for his valuable input