View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default How to capture screen through VBA?



funny though it is:

VB6 can simply sendkeys {PrtSc}
VBA cant do it..
(Word has a workaround)

see API code in referenced thread.

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Tim Coddington wrote :

Snaggit did look interesting
I wonder if there is any way to use 'SendKeys' to send Alt
PrintScreen to Windows?

Syntax

SendKeys string[, wait]

That might be just what the doctor ordered without having to access
another package.