Saving a screen capture ~ PrintScreen (Excel '97)

[phendrena]

Hi,

I have code setup to do screen capture based on the 'Sendkeys' method (i'll study API calls at a later date).
How can I then save what has been captured using print screen?

Thanks,

[Bob Phillips]

Download a free screen capture utility, it is far simpler.

[phendrena]

Download a free screen capture utility, it is far simpler.
In an ideal world that's what I would like to do, however as i'm not the only one who would need this facility and its not practical, or probably acceptable under the companys acceptable use policy, for me to do that. I take that coding something that would save the screenshot as a .bmp for example is a major pain in the rear! If its not practical i'll explore other options.

Thanks for the reply xld

[Bob Phillips]

No it is possible, but you have so many options (rang, image, window, etc.) ad you are re-inventing the wheel.