Macro for inserting pictures from folder to Excel

Closed
Grig280390 Posts 1 Registration date Tuesday March 20, 2018 Status Member Last seen March 20, 2018 - Updated on Mar 20, 2018 at 12:01 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Mar 20, 2018 at 12:19 PM
Hi guys I am new here and would appreciate any help for the following issue:

I have an excel sheet with more than 100 product codes (e.g. 00501-0165) in column C.
Now I have another folder (path: C:\Users\arno01\Desktop\Onboarding\PICTURES) which contains all the pictures in jpeg. format for all these product codes. The pictures have the same name as the product codes.

Now I am looking for a macro which assigns the respective pictures from the folder next to the product codes in Column A in ecxel.

Can anybody help me with this issue?

Thank you very much in advance.

Grig

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Mar 20, 2018 at 12:19 PM
hi Grig,

Have a look a the following thread:
https://ccm.net/forum/affich-716722-insert-picture-in-excel-macro-which-takes-the-file-name-refrence
Check out post 10 in particular. There is a code where the green text explains the code lines. Remove the parts you don't need.

Can you make it work?

Best regards,
Trowa