Hello All,

The code that I have been using for production reports takes the entire name of a part and pulls the picture based on the entire name. The issue with this is that some pictures are named inconsistently.

I was hoping for a macro that can pull a .jpg file that contains a piece of the number before the right-most dash.

ISSUE - There is multiple files that contain the number before the right-most dash.

Example:

I want to pull a picture that contains A1234 in it...

there are pictures in the folder labeled A1234-01 , A1234-02 , A1234-01_A etc.

It really doesn't matter which one it picks out of that group.