Dynamically Updating Image (ActiveX Image Control?)

[VTHokie11]

Hello thank you for looking at this thread! My workbook simply has multiple columns of data which will be summarized visually in a tag cloud (I have the tag cloud part taken care of already creating either a jpg or png, I simply have to change the extension within a batch file to change between picture formats)

I need to have the tag cloud image display and update depending on which column the user would like to summarize (for now I have simplified the issue by only having one of the data columns in my workbook, and will worry about the user selection of the data column to be summarized later).

My Main Question:

Focusing on the image display and updating now, whether it be an ActiveX Image Control or any other way (open to any ideas advice). I've been playing around manually before I try and code it and I can not get either a jpg or png file to attach to the ActiveX control (both of which cause an Invalid Picture Message).

The file name can stay the same if need be and for now I think/assume that'd be easiest (I have my Tag cloud generator just replacing the previously existing image file of the same name).

Would ActiveX control be the way to go for this dynamically changing image? If not how would you recommend I try and tackle this. Please let me know if I've not been clear and much thanks in advance!

 

[Andrew Poulsom]

I don't think the location matters because you are getting an Invalid Picture error. If you think it matters try putting the jpgs on your desktop and assigning one of those to the control. If you choose Insert|Picture can you put one of your jpgs on a worksheet?

 

[VTHokie11]

Hmmm... yea I tested whether the location mattered and found it still produced the error when placed in the same folder as an image which was successfully attached to the ActiveX image control.

I also just successfully inserted-->picture the same jpeg image which will not attach to the ActiveX image control. So it can be inserted as a picture but not attached to the ActiveX image control. I don't get it but its something to do with the image file since I successfully attached a different image. Thank you so much Andrew!

 

[VTHokie11]

Perhaps since it can be successfully inserted as a picture I should have my code insert it as a picture then when a new word cloud image file has been produced and it needs to be updated, delete and insert again? I just thought ActiveX would be an easier way of updating the image like this.

I don't know too much about ActiveX controls but as long as I can continue to display the updated image file I'd be happy. Thanks for all your help Andrew at least were eliminating reasons why its not working.