Insert Picture from a Folder to Excel if it meets specific content

[tantcu]

Hello,

I'm trying to explain as clear as possible here. I got a VBA code to insert an image file from a specific folder to my excel workbook. However, this code requires the image file name has to be as an item number.

For example, if I want to pull an image of an item called "17001", I have to enter "17001" from excel and use VBA to pull that image from the folder. The name of the file needs to be "17001.jpg" to be able to pull the image.

It is very simple until recently when I received an image database from the coworker and he names the images with item number and item description. Now the name of the file contains something like "17001_Rubber_Ball_Large_Size.jpg". I could not pull the image from the folder anymore since the file name has different description from the cell value. I just want to use the Item number to search for the image.

Could you please help me modify the vba code below so that it can look up the item number 17001 from the cell value and automatically retrieve the file name which contain the item number and its description ?

Please Login or Register  to view this content.

[cytop]

Assuming the format remains the same, for example starting with 17001, and only 1 file name starts with '17001', then

Please Login or Register  to view this content.

should do it...

I'd be careful with this line

Please Login or Register  to view this content.

FileName will only contain the file name ("17001_Rubber_Ball_Large_Size.jpg") - you will probably have to add the full path same as you did for the DIR...

[tantcu]

You are right. The specific file did not find as it need the full path for the Set Pic. How can we address this problem?

[tantcu]

Assuming the format remains the same, for example starting with 17001, and only 1 file name starts with '17001', then

Please Login or Register  to view this content.

should do it...

I'd be careful with this line

Please Login or Register  to view this content.

FileName will only contain the file name ("17001_Rubber_Ball_Large_Size.jpg") - you will probably have to add the full path same as you did for the DIR...

Could you help address this issue?