loading a bitmap into an image control from the clipboard

[Loane Sharp]

Hi there.

In code, can I load a bitmap into an image control from the clipboard?

I've stored the bitmap onto the clipboard in code as follows:

ActiveSheet.ChartObjects("Chart 1").CopyPicture xlScreen, xlBitmap

Normally, I would load a bitmap from a file as follows:

UserForm1.Image1.Picture = LoadPicture(pathname).

Can anyone help?
Thanks,
Loane

 

[Bob Phillips]

Loaned,

Does this not work?

ActiveSheet.Paste

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Andy Pope]

Hi Loane,

Check out Stephen Bullen's PastePicture example, it requires some quite
complex code and API usage.
(http://www.bmsltd.ie/Excel/Default.htm)

Or a maybe an alternative approach, especially if you are after placing
a chart on a userform, from John Walkenbach.
(http://www.j-walk.com/ss/excel/tips/tip66.htm)

Cheers
Andy

 

[Loane Sharp]

Hi Andy,
Thanks very much ... working perfectly.
Cheers,
Loane

 

[Loane Sharp]

Hi Bob,
Thanks very much for the tip.
Cheers,
Loane