How can I use a VBA macro to replace an existing image with file with name of cell?

My idea is to write a macro which is assigned to a button that does the same thing as right-clicking the image and using "Change picture..." and then uses information in a cell to find the correct picture (Lastname, firstname.jpg).

Having never worked with excel macros before, you can imagine my dilemma.

Lets say all the pictures are stored under this file path: C:\MyLocalData\john.smith\Pictures\Portraits
and all use this naming convention: LASTNAME, FIRSTNAME.JPG

If someone could help me out with this issue that would be amazing! Thanks in advance.

Hey AlphaFrog,

Yes, the image does insert rotated 90 degrees even if when I open the image file normally it has the correct orientation. I rotated, then un-rotated the image and saved it again in the correct orientation and then the image came in the correct way.

I was wondering if you know a way to make a button that would rotate the image by 90 degrees per click? That way I could click that button whenever it does not insert right.

Thanks!

Hi henki111,

I was wondering if you know a way to make a button that would rotate the image by 90 degrees per click?

See the attached modified copy of your sample Workbook. Select a Picture or Shape, then Left Click the CommandButton to rotate the shape +90 degrees.
This DOES NOT work on Active X Objects.

Please Login or Register  to view this content.

Lewis