asked on
How can I programmatically change the image of an existing picture in an Excel sheet with the image from a new gif file
I have a picture object in a sheet. I need to have a different image there depending on some conditions. I have tried changing it with:
reportSheet.Pictures("Logo
But the object doesn't seem to support this. How can I do this?
reportSheet.Pictures("Logo
But the object doesn't seem to support this. How can I do this?
Visual Basic ClassicMicrosoft Excel
Last Comment
Rory Archibald
If you are using a picture from the Drawing toolbar, you could just delete it and add a new one?
ASKER
Rory -- how would I do this while maintaining the exact size and location of the existing image?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
https://www.experts-exchange.com/questions/23235957/My-picture-does-not-want-to-change-for-no-reason.html