Hi there, I have files located on my hdd that are sequencially numbered, i want to check for breaks in the sequence.
What I have so far: My app populates a filelist box with the files in the folder, i have determined the first and last files in the folder.
What I need: Now all I need is to run a loop to check that the increments are sequencial. If there is a break in the sequence then that filename must be placed in a “Missing Files” list box.
Eg of file names: abc000354 up to abc001264
I was going to use left(strFilename,3) to remove words, but i would prefer checking the entire file name, this will help if the files ever change eg: bcd00452 to efd00235
Would appreciate help on this one.
Thanks
