Determine path to picture displayed in image control

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

I know how to display a picture on the ActiveX image control, eg.
MyImage.Object.Picture = LoadPicture(strImagePath)

But does anyone know how to subsequently retrieve the image path from
the object? I've tried variations on
strImagePath = MyImage.Object.Picture
but without success.

FYI, I the images are in a worksheet and are being used to represent
various process operations. I'd prefer to keep track of what they are
through the image property rather than the name property since users
could copy/paste the objects resulting in a default xl generated name.

Thanks a lot,
Andrew
 
Thanks a lot - .AlternativeText will work perfectly for me - in fact I
don't need to know the full path just the object type name so storing
just that is actually preferable.

I went with the ActiveX image control because it gives me the option
of trapping a right click event and maybe displaying some options that
way (although undecided whether I'll actually go that route). Did you
have a better alternative in mind?

Cheers,
Andrew
 
Back
Top