Has anyone found a way to get Stephen Bullens PastePicture code...
http://www.oaltd.co.uk/Excel/Default.htm
....to work in Excel 2007?

It does an excellent job for me in an app that I developed in Excel
2003 but falls over in 2007. Or is it perhaps the fault of the Vista
user32.dll?

I have two machines, one running Office 2003 on XP the other running
Office 2007 on Vista. On the Vista machine when the
IsClipBoardAvailable function is passed an xlBitmap type it returns 0.
As a result PastePicture returns nothing. I can get it to work if I
pass the the argument as xlPicture and save it as a .emf but I need
a .bmp because I then want to load the picture into a control.

The problem can be demonstrated by running Stephen's PastePicture.xls
example workbook. On my Vista/Excel 2007 machine the chart picture
only displays if the picture type is set to Metafile on the demo form.

Br, Nick