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.
Bookmarks