Code to open a file based on Cell Data, and a WildCard

[stmur]

Good Day!

Cant seem to get the head around this one:
trying to open an excel file based on cell value, and also has some unknown numbers/letters at the end of it..

For instance, I know that the file name starts with 4 bracketed numbers which are known. ie. (6345)
then after the bracket, there is a customer order number which could be anything, and any length. so the result is: (6345)***********

what i need to do is use the 4 known numbers (which are variable, but will be in a cell) and open the file from a known file path

yell out if i need to give more info!

thanks in advance

 

[Jerry Sullivan]

Hi stmur,

Here's a thread that has some code in Post #4 that could be used as a starting point for a macro that does what you describe.
http://www.mrexcel.com/forum/excel-...-code-copy-file-based-keywords-file-name.html

In that example the user was copying all files with names that contained keywords from a list.
You could modify this to use just one keyword and to open the file(s) instead of copying it.

If it's possible that you'll have more than one match, you'll need to decide what to do in that case.

Just ask if you want some help adapting this.