Save clipboard image to file

[Netherby]

Hi,

I have an application that takes info from my database, processs it and then places a bitmap image on the clipboard.

I know the image is there because I can manually paste it into Word or PowerPoint.

What I want to do is to get VBA to save the image as a bmp file so I can then use it in an Access report. Can anyone help?

If I can't save the image, is there another way to get it into a report?

Thanks

 

[kjv1611]

So, the file is already in bitmap (BMP) format, and you basiclaly need to save it from the clipboard to a static location?

If so, all you need to do is access the clipboard via VBA:

http://lmgtfy.com/?q=vba+clipboard

First reference:

http://word.mvps.org/FAQS/MacrosVBA/ManipulateClipboard.htm

Tells how to get text, not sure if that can be used for objects as well.

Another detailed reference:

http://www.cpearson.com/Excel/Clipboard.aspx

Also, here's a discussion, with at least one posting of a fair amount of code dealing with the clipboard.

http://www.mrexcel.com/forum/showthread.php?t=53517

Once you have it sorted out as to how to get to the clipboard, you'll need to save the file to your folder location. I believe you can use a few different methods to do so. I can't remember them off-hand, but when you get to that point, if you still need help, I'm pretty sure I can dig up some info - on web, as well as my own examples.

 

[MaxDD]

If you want to take a short way, you can try AccessImagine component -

http://access.bukrek.net

It can get the image from clipboard to database with one click.

"Be aware of WordPress, it provokes to write bloggy-style..." (c) Gunna