GetOpenFilename Multi select Issue

[hsk]

I have a macro which allows user to select number of files from folder and macro lists all the files(paths) in a sheet.

This works good only the problem is -
The order in which the files are written in excel sheet is not the same as that selected by user.

e.g.
Below code returns list of files in array fileToOpen.

fileToOpen = Application.GetOpenFilename(FileFilter:="Text Files (*.txt), *.txt", MultiSelect:=True)

Problem is the array is not sorted, is there any thing I can do so that the order will be preseved??

 

[GlennUK]

Can you explain what you mean by the order that was selected by the user? Do you mean that each click in multiselecting should be used in the order?

 

[hsk]

Can you explain what you mean by the order that was selected by the user? Do you mean that each click in multiselecting should be used in the order?

Yes, if that's possible ...
Otherwise, I would want to sort the list on the file names.
Is there any way ?

 

[GlennUK]

As far as I know the names always come out in file name order. Are you not getting that?