Hey ChrisOK, is it reasonable to think you have abandoned this both here and at another forum you posted to ?

@NoSparks, actually, no it's not abandoned, I was pulled away for other project deadlines and got back to it this -- this morning -- started re-testing and have encountered an error on the 'fm' line of the code -- trying to figure out why it stopped working... I also expanded the lookup table and was going to post and updated working copy for others to use that would handle a larger variety of file types (lengths) - once I get it working again. (I'll try to get it resolved, updated and closed out by EOD if possible) Thank you

@BobBridges, @NoSparks,

Encountered issues with a Runtime error "5" Invalid procedure call or argument.
Kept turning yellow on the "fm" line of the lower part of the script -- been battling it all morning in between other work interruptions but was FINALLY able to get the updated file working again -- started from scratch w/ the ("x") file and worked forward again... (new file name is diff so it doesn't overwrite others previously downloaded). This solution is amazing and appreciate everyone's help to fine a solution!

I'm attaching a cleaned up version of the working file (which now includes my expanded lookup table (Columns N&O) you refer to as the "Collection" in the script.

The expanded table will allow a larger variety of file lengths/variations which resolved my issues with so many different lengths going on..
Thanks greatly for your help getting this working again!

Attached Files

x_EXPANDED.xlsm (31.9 KB, 10 views)

Always nice to be appreciated, ChrisOK. One thing I don't understand: I suggested (twice) that it might be simpler to use a single formula, using not the MID function but RIGHT and LEFT. You could put that formula in column K, omit the table of formula entirely and not have to write or use any VBA program. Did you have some reason not to want to use that solution, or did you just not see it (twice)?