@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!
|