A very useful question was asked in stackoverflow – I want to use vba to take a screenshot (which will then be sent as an email attachment). Ideally, I'd like to take a screenshot of just the active form. Is there any way to do this? I’ve been vaguely thinking about this for years. Now this won’t help if you have an error message on the screen.
If you’ll notice my comment I suggest saving the created BMP image in the clipboard into a table. I didn’t elaborate on exactly how to do that. Possibly the code at Lebans OLEtoDisk might be enough to get you going.
My friend Jim really likes using Bug Shooting as that integrates very nicely with BugTracker.Net which his development shop uses. However this requires installation on PCs, etc, etc.