Grabbing image from clipboard & saving as file

[bpurser]

I have been googling my behind off this morning, looking for a way to have Access grab an image from the clipboard (put there with PrintScreen key in an external piece of software, and save it as a file (jpg).

Since VBA doesn't expose the clipboard object, it's a cumbersome issue, and I now know many ways to copy text to the clipboard and back to a control--which may come in handy one day but doesn't solve my problem.

Anyone have a direction I can investigate on this?

Thanks--

Ben

 

[mhartman1]

Here you go.......

http://www.cpearson.com/excel/clipboard.htm

Regards
Mark

 

[mhartman1]

And one more....

http://www.vba-programmer.com/Snippets/Code_VB/Simulate_Ctrl_C_for_Clipboard_Copy.html

Regards
Mark

 

[bpurser]

Appreciate the pointers to those pieces of code--I had found them in my search. This is definitely not my area of expertise, but those appear to be both text-centric and an automation of the Ctrl-C and Ctrl-V keystrokes--and unless I am missing something (ENTIRELY possible!) I don't think they get me home.

So let me more fully explain the sitch..taking screen prints of WMV files, then pasting them into my photo management software (the fact that I am doing this is an indication that Mothers-In-Law can be a pain!!).

What I am hoping to do is have an Access db open, with a form timer event that checks the clipboard every half-second or so, sees if the clipboard has data, and saves that data as a jpg file on my HD, then clears the clipboard. Then I can just let the movie play, hit "PrintScreen" every so often, and not have to stop the video, switch to the photo software, and manually paste, name the file, switch back to the video...and repeat ad nauseam.

Will the code you pointed me to allow me to do that?

If so, can you give me a bit of advice as to how to make that happen?

Thanks--

Ben