Find Open File with Variable Name

[norths03]

Find and Open File with Variable Name

I'm trying to use VB to open and modify a set of 200 files. My team gets about 1,000 new items a month and we need to add these to their respective templates (the 200 files) based on their product classes. The templates are named by their major and minor product class... for instance 1901 0120. Unfortunately they have additional information after the product class like if they have been uploaded and when the most current data was added.

I need a way to find a file and open it based on the product class, ignoring what's after that. Each major minor product class will only have 1 file.

Example file names: (xls or xlsx)
3001 0940 v3.0 Uploaded
1001 0740 v3.0 New Items 3-2010
2201 0120 v3.0 Ready 3-2010
1801 0610 v3.0 Uploaded 3-2010

Thanks in advance for any help with this.

 

[Andrew Poulsom]

Re: Find and Open File with Variable Name

You can use Dir with a wildcard and loop.

http://www.dailydoseofexcel.com/archives/2004/04/15/the-dir-function/