PDA

View Full Version : use VBA to capture screenshot of a form



wolf.stalker
06-08-2011, 03:50 PM
Greeting all and thanks for any contribution you can help with :hi:

My Goal is : an end user has lanuched one of my custom built forms. the user enters in data, and then hits the "update" button. At this time, I want to capture this screen shot and then be able to send it to an email address i have hardcoded.

i am pretty sure i have the email part down (found a routine months ago) but i have no idea how to capture a screen shot unless it's done with send keys maybe?

anyway, thanks for your help!

-Will

Benzadeus
06-09-2011, 04:54 AM
Have you read this?
http://support.microsoft.com/kb/318188

The example below saves a Image control:
http://www.sqldrill.com/excel/programming-vba-vb-c-etc/279245-copy-picture-image-control.html