excel king required for this one

[holdend]

hi guys, i have a folder in excel 97 that contains 31 spreadsheets. they need to be named "1st", "2nd" "3rd" etc etc....

any of you guys know how i can get them to be in order when the folder is opened by me or anyone else on my network?
By in order i mean 1st, 2nd 3rd 4th

At the moment they are all over the place, think in alphapet order which is no good to me

 

[cheveley]

a round about way to do it would be to keep the files names the same but change the order in which the appear in the folder when you open a file.

this can be changed so that files appear in date modified order.

 

[tusharm]

(A) I don't know of any way for VBA or VB or VBScript to know when someone opens a folder. Might be with some API call using a callback function but I don't know of one.

(B) How would any software module know what file becomes 1st, what becomes 2nd, and so on?