Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading files in alphabetic order
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change a list into alphabetic order | Excel Discussion (Misc queries) | |||
How do I set a column in alphabetic order? | Excel Discussion (Misc queries) | |||
can i rearrange the following names in alphabetic order.. | Excel Programming | |||
can i rearrange names in alphabetic order... | Excel Discussion (Misc queries) | |||
alphabetic order | Excel Programming |