Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 39
Default screen capture

is there a way to programically simulate the "ALT+PRTSCR" to capture
the screen image which would be stored in the clipboard?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 22,906
Default 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?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel screen capture to capture cells and row and column headings jayray Excel Discussion (Misc queries) 5 November 2nd 07 11:01 PM
screen capture [email protected] Excel Programming 1 June 25th 07 11:43 AM
Capture Screen Position Paige Excel Programming 6 June 13th 07 11:40 PM
Screen shots capture matt dunbar Excel Programming 2 October 8th 04 03:03 PM
How to capture screen through VBA? Bill Choy[_2_] Excel Programming 3 July 23rd 04 05:00 AM


All times are GMT +1. The time now is 08:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"