Hello everyone!
I've got an EXCEL/VBA application where I need to allow the user to create and reference images to be dynamically, placed (and sized to fit within a specified range).
I've tried several approaches, but favor the following solution THUS FAR.
(1) the user will have to create an object (in this case a label) sized to the area they wish to have the image (they are corporate logos).
(2) they will also have to know the name of the image and place it in a cell or textbox which I will define (so that I can reference it in the following code.
(3) I will loop thru the process loading the image associated with a given entity.
ActiveSheet.Label1.Picture = LoadPicture("image.jpg"
TWO QUESTIONS:
(1) Is there a better way?
(2) As I loop thru and change images, EXCEL is chewing up memory. How do I free it up each time?
THANKS!!
I've got an EXCEL/VBA application where I need to allow the user to create and reference images to be dynamically, placed (and sized to fit within a specified range).
I've tried several approaches, but favor the following solution THUS FAR.
(1) the user will have to create an object (in this case a label) sized to the area they wish to have the image (they are corporate logos).
(2) they will also have to know the name of the image and place it in a cell or textbox which I will define (so that I can reference it in the following code.
(3) I will loop thru the process loading the image associated with a given entity.
ActiveSheet.Label1.Picture = LoadPicture("image.jpg"
TWO QUESTIONS:
(1) Is there a better way?
(2) As I loop thru and change images, EXCEL is chewing up memory. How do I free it up each time?
THANKS!!