Automatic jpg image file extraction

%3CLINGO-SUB%20id%3D%22lingo-sub-2907754%22%20slang%3D%22en-US%22%3EAutomatic%20jpg%20image%20file%20extraction%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2907754%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20list%20of%20parts%20in%20the%20first%20column.%20In%20a%20separate%20folder%20I%20have%20a%20jpg%20image%20for%20each%20part.%20I%20would%20like%20to%20create%20a%20system%20whereby%20if%20a%20specific%20part%20number%20is%20present%20in%20the%20first%20column%20it%20will%20automatically%20extract%20the%20corresponding%20jpg%20image%20from%20the%20folder%20and%20place%20it%20in%20a%20cell%20to%20the%20right%20of%20the%20first%20column.%20Likewise%20if%20a%20part%20is%20removed%20from%20the%20first%20column%20I%20want%20the%20corresponding%20image%20to%20be%20removed%20from%20the%20sheet.%20If%20this%20is%20possible%20then%20any%20assistance%20would%20be%20appreciated.%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2907754%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I have a list of parts in the first column. In a separate folder I have a jpg image for each part. I would like to create a system whereby if a specific part number is present in the first column it will automatically extract the corresponding jpg image from the folder and place it in a cell to the right of the first column. Likewise if a part is removed from the first column I want the corresponding image to be removed from the sheet. If this is possible then any assistance would be appreciated. Thanks in advance.

1 Reply

@GarethHonour 

There is the simple possibility to do this via the comments.

Can also be taken from other folders with VBA, but it also takes time accordingly.
If you insert a graphic / image in a comment, it will be visible when you mouse-over.
Here is the installation description:
Cursor in cell with comment -
-> right mouse button
-> edit comment
-> right mouse button click on the edge of the comment field
(an art piece in itself)
-> Select Format Comment
-> colors and lines
-> DropDown color
-> fill effects
-> Graphics tab
-> select graphic

 

Example file inserted.

 

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.