ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   screen capture (https://www.excelbanter.com/excel-programming/435247-screen-capture.html)

miek

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

Jacob Skaria

screen capture
 
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
---------------
Jacob Skaria


"miek" wrote:

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


Gord Dibben

screen capture
 
How much of the screen do you want to capture?

SHIFT + EditCopy Picure will catch a selected range from a sheet.


Gord Dibben MS Excel MVP

On Wed, 21 Oct 2009 09:51:01 -0700, miek
wrote:

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




All times are GMT +1. The time now is 11:41 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com