Find Open File with Variable Name

norths03

New Member
Joined
Oct 20, 2009
Messages
9
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.
 
Last edited:

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,099,166
Messages
5,467,021
Members
406,518
Latest member
SilverSixx

This Week's Hot Topics

Top