Hello all. Thanks in advance for reading my post.
This topic can be found all over the place but I'm still stuck when it comes to finding the picture using a wild card.
I have a spreadsheet with part numbers in column A. I want to find the picture from a folder and then insert it in column be with a size that matches the row and column sizes or just resize the row and column when it gets inserted.
Where I'm stuck at is the part number in column A may not include the entire picture name. Example: Part number is column A is "ABCDEFG". The picture name is "ABCDEFG_001.png". I've tried using an asterisk for a wild card in various places in the below code but It gives me the "Application-defined or object-defined error" message. If the part number matches the picture name exactly, it does what I'm expecting (except for picture size).
The code I'm using is below. It is not my code but I have tried to adapt it to my needs and it doesn't go through all the part numbers is column A, only the active cell which will be my next opportunity for improvement. I hope all that makes sense to everyone and again, thanks in advance for your help and guidance.
Bookmarks