Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading a bitmap into an image control from the clipboard
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading a bitmap into an image control from the clipboard
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) "Loane Sharp" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading a bitmap into an image control from the clipboard
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 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading a bitmap into an image control from the clipboard
Hi Andy,
Thanks very much ... working perfectly. Cheers, Loane "Andy Pope" wrote in message ... 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 wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
loading a bitmap into an image control from the clipboard
Hi Bob,
Thanks very much for the tip. Cheers, Loane "Bob Phillips" wrote in message ... 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) "Loane Sharp" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
enter bitmap image pixel data to cells | New Users to Excel | |||
Saving clipboard image as BMP through VBA in Excel | Excel Discussion (Misc queries) | |||
Strange behaviour - loading Excel clears Clipboard | Excel Discussion (Misc queries) | |||
Image not loading when opening Workbook | Excel Discussion (Misc queries) | |||
Putting an image into the clipboard | Excel Programming |