C
cejones
I have an Excel spreadsheet that I need to pull sixteen pictures into.
I have then evenly spaced out from each other.
I have found no way to insert a picture "into" a cell... which would be
the best way to arrange these pictures... so I created a square
autoshape and used the picture as the color fill/background.
It works great for one set of pictures... but I plan on updating this
excel sheet with new photos every couple of days and would like to
create a folder with all 16 pictures named 1.jpg, 2.jpg, etc... and
have a macro that goes into each autoshape and changes the color
fill/background to the new picture file that I manual place into the
appropriate folder...
Is this the easiest way to do this? Or is there a better way?
I am using Excel 2002 SP2
Thanks for any help
Chris
I have then evenly spaced out from each other.
I have found no way to insert a picture "into" a cell... which would be
the best way to arrange these pictures... so I created a square
autoshape and used the picture as the color fill/background.
It works great for one set of pictures... but I plan on updating this
excel sheet with new photos every couple of days and would like to
create a folder with all 16 pictures named 1.jpg, 2.jpg, etc... and
have a macro that goes into each autoshape and changes the color
fill/background to the new picture file that I manual place into the
appropriate folder...
Is this the easiest way to do this? Or is there a better way?
I am using Excel 2002 SP2
Thanks for any help
Chris