Ideally I would want to do it in Access, but it is fine if it is in another office app.

I want to create a macro that will save the contents of the clipboard (if a picture, especially if someone has pressed "printscreen") to a jpg, bmp or png file to a location on their computer. I would prefer a straight save to the location rather than pasting it to word or paint and saving it (i did see one sort of solution using sendkeys and timing events, but that wouldn't be suitable).

Thanks for your reply. Hope what I am looking for is clearer to you.