@ blink0k, thanks again and yes my only options to date are to use arrays or abandon.
I have found 3 array options that will work, sort, reverse or simply assign my data to each array cell using a bit of maths to reverse the cell numbers. The first 2 methods, and when I say first, I mean sort or reverse array, just in case there is any confusion of which order of methods I refer
, both add a small time delay so the last method seems to be the best at the moment.
eg instead of assigning cell numbers by;
for letter = 1 to 26
alphabet[letter] = fn$
etc
change to:
for letter = 1 to 26
alphabet[26-letter+1] = fn$
etc
This should make cell no 1 = A through to cell no 26 = Z.
(I haven't even started on several hundreds of files yet which will have the same problem).
The biggest problem though for me is if and when we get an update to make the getfirst more logical and default it to alphabetical order. Then it will mean re-writing quite a large chunk as this windows app which is primarily to do with folders and files. Some PJ feedback would be appreciated.
So, do I abandon, postpone or just go back to DBPro where IanM matrix is great?