Macro for inserting pictures from folder to Excel

Posts
1
Registration date
Tuesday March 20, 2018
Last seen
March 20, 2018
-
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
See more 

Your reply

1 reply

Posts
2435
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 4, 2018
0
Thank you
hi Grig,

Have a look a the following thread:
http://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

Respond to TrowaD