Previous Topic Next Topic

Macro for inserting pictures from folder to Excel

Closed
Grig280390 Posts 1 Registration date Tuesday 20 March 2018 Status Member Last seen 20 March 2018 - 20 Mar 2018 à 09:02
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 20 Mar 2018 à 12:19
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

Réponse 1 / 1
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 555
20 Mar 2018 à 12:19
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

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
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response