Turn on the macro recorder (Tools | Macro Record new macro...),
insert an image from a file, delete the inserted image, and turn off
the recorder.

XL will give you the necessary starter code that you can then modify
and generalize.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article , beeawwb
says...
What about with VBA? This is something that's intrigued me for a while,
and I've been waiting for a project where I might get to test it out.

Specifically, I was thinking in terms of a card game. Have an array of
52 cards, and 52 card pictures stored on the hard drive. Based upon
what random value was called, load a picture.

So, for example, if the array randomly selects DI,4 (4 of Diamonds)
then make the first picture DI4.jpg

Any way to have VBA code change / modify OLE objects? I know in access
I had a way to do it, where I stored 52 pictures as an OLE table. But
Excel doesnt work that way.

So, any light that can be shed on that, thanks. :)

-Bob


---
Message posted from http://www.ExcelForum.com/