Macro for inserting pictures from folder to Excel

Grig280390 1 Posts Tuesday March 20, 2018Registration date March 20, 2018 Last seen - Mar 20, 2018 at 09:02 AM - Latest reply: TrowaD 2340 Posts Sunday September 12, 2010Registration dateModeratorStatus April 19, 2018 Last seen
- 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
See more 

1 reply

Reply to this topic
TrowaD 2340 Posts Sunday September 12, 2010Registration dateModeratorStatus April 19, 2018 Last seen - Mar 20, 2018 at 12:19 PM
0
Helpful
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