Comments by Dave_6 (Top 2 by date)

Dave_6 24-Mar-11 15:56pm View

Are you saying that the image format I selected is not relevant? When I put png data on the clipboard it is really bitmap data?
I do not put bitmap data on the clipboard. I put png data on the clipboard. And I want to put jpeg data on the clipboard. Once I have the png image data on the clipboard, I switch to Excel and select pastespecial. The only paste option is PNG. Bitmap is not an option.
No other image format is available to paste. However, I if paste the png image into Excel, then copy it from within Excel, the new pastespecial list shows many different image formats available to paste, including jpeg. So I know it is possible to paste jpeg data from the clipboard, just as it was possible to paste png data from the clipboard. If I use Paint instead of Excel the png image is not available to paste. Paint only accepts bitmap data.

Dave_6 24-Mar-11 11:31am View

Thank for responding. I'd already read the article. Well done.
Perhaps I am having trouble understanding... I need to put a jpeg on the clipboard. SetImage will only put a bitmap on the clipboard. SetDataObject has many image format options. That's how I worked out getting the png format. However, the jpeg version of my image is less than half the size of the png. If I paste the image into Excel, then manually copy it, pastespecial will show many differnt image formats available, including jpeg. How can I get my image onto the clipboard as jpeg?