screen capture

[miek]

is there a way to programically simulate the "ALT+PRTSCR" to capture
the screen image which would be stored in the clipboard?

 

[Jacob Skaria]

Check out
http://word.mvps.org/FAQS/MacrosVBA/PrtSc.htm

'Within excel...you can try the below code and try pasting this to a new
worksheet
Cells.CopyPicture Appearance:=xlScreen, Format:=xlPicture

If this post helps click Yes

 

[Gord Dibben]

How much of the screen do you want to capture?

SHIFT + Edit>Copy Picure will catch a selected range from a sheet.


Gord Dibben MS Excel MVP