Loop through sets of files and perform action on each set

I am trying to loop through a set of files which are in sets. With each set i want to update a value in the file to the same new value.

Problem is in how to check when the first member of a new fileset is being read and to alter the value for the new set and then do the same for each new set encountered.

The file sets are identifiable by the Left(filename,6) function. So when this changes it is a new set.

So problem is how to read and store the first fileset identifier and then to loop, do the changes, detect the new filename and input the new value to that set.

It looked easy but when storing the initial filename in the loop and comparing it to the next one it overwrites the stored variable.

There must be an easy way round it but i am stuck!

Thanks

Neil

Hi

The files are all in the same folder with .tpl as extension. They are essentially text files with multiple lines with a parameter name and value on each line. They are the only files in the folder currently.

I have code to loop through and read each file content (matching the extn .tpl) and split each line into a parameter name and value (stored in a dictionary so I can refer easily to any parameters' value).

Currently, I can update a value ok and write it back.

However, it is just the logic of altering a value or values in a SET of files with the same filename identifier that escapes me.

So essentially I load the first file, it has an identifier of "AUDCAD" so update it with the value. The second file has again an identifier of "AUDCAD" so update that too and so on.

At some point, the next file has a new identifier of "USDJPY" so for each of these the next value (which is looked up from another small array) is written and so on.

There are currently no values stored in cells in the workbook just arrays handled by VBA. The code is run from excel so it does not rule that out if it helps, but it would be better handled in the VBA if possible.

Not sure if that is clearer or not

Regards

Neil