Previous Topic Next Topic

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 Contributor 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
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 555
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

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to add Rows automatically based on Cell Value In Excel?
Raj_2823 -
TrowaD -

7 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses