Greetings,
I am new to VBA and trying to write a program that will open a group of files whose name is in the format S1T1C1.vfc where the S1T1 part of the name will remain constant (S refers to subject number and T refers to trial number) but the "C1" (condition) will be different every time since we randomize our trials. I have a working loop that will open all the trials for a particular subject but only if I remove the last two letters of the file name in the folder.

Is there a way to only look at the first part of the file name (which will be unique) and ignore the last two characters?

Thanks for any help you can provide,
Marcus