S
Sören_Marodören
I use the following lines to multi select files in a directory.
:
:
Filt = "Text Files (*.txt),*.txt," & _
"Comma Separated Files (*.csv),*.csv," & _
"ASCII Files (*.asc),*.asc," & _
"All Files (*.*),*.*"
FilterIndex = 1
Title = "Select files:"
AllFileNamn = Application.GetOpenFilename _
(FileFilter:=Filt, _
FilterIndex:=FilterIndex, _
Title:=Title, _
MultiSelect:=True)
:
:
When I use the AllFileName to read in the files to Excel, the files are not
in alphabetic order. And they are not in order of when I selected them. I
don't know what order they are.
Can some one tell me why it works in this way and how I can get it in
alphabetic order (or maybe other useful orders)?
Best regards,
/Sören Nilsson
:
:
Filt = "Text Files (*.txt),*.txt," & _
"Comma Separated Files (*.csv),*.csv," & _
"ASCII Files (*.asc),*.asc," & _
"All Files (*.*),*.*"
FilterIndex = 1
Title = "Select files:"
AllFileNamn = Application.GetOpenFilename _
(FileFilter:=Filt, _
FilterIndex:=FilterIndex, _
Title:=Title, _
MultiSelect:=True)
:
:
When I use the AllFileName to read in the files to Excel, the files are not
in alphabetic order. And they are not in order of when I selected them. I
don't know what order they are.
Can some one tell me why it works in this way and how I can get it in
alphabetic order (or maybe other useful orders)?
Best regards,
/Sören Nilsson