Macro for inserting pictures from folder to Excel

[Closed]
Report
Posts
1
Registration date
Tuesday March 20, 2018
Status
Member
Last seen
March 20, 2018
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
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 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
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