Excel VBA Setting picture property of image control

Question

4.00/5 (1 vote)

See more:

I have 2 excel workbooks.

I want to place empty image controls on sheets in Book A and set the picture property of them at run time by importing or getting the image information somehow from the images either embedded or stored in some fashion in book B which would be sent out with book A.

As far as i can determine, I can only do this with loadPicture(path) which is no good for this as there isn't a path to the image. I want to get around the need to reference remote directories which not everyone will have acess to.

Any ideas if or how I can do this?

Thanks

Posted 17-May-11 3:34am

GedSmith

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

S Houghtelin · Answer 1 · 2011-05-17T05:39:00

Solution 1

Use cut and paste using the clipboard. It is something like Set Picture1.picture = clipboard.getdata(ImageObj1) from workbook A whiich places the picture into the clipboard, then paste it into workbook B.

Do a search for Clipboard in the VBA help from the VBA editor for the method.

Excel VBA Setting picture property of image control

1 solution

Solution 1

Add your solution here

Preview 0

Excel VBA Setting picture property of image control

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us