Sorting in Excel like in Window Explorer

[Dolly]

Hello,

I just extract a list of file names from a folder to an excel file. However,
the sorting method in the Explorer is different from that in Excel, but I
need print both of them in the same order. I need the excel files to check
the copies printed from the files in the folders. There are handreds of
files. The file names contain both number and letters, such as:
DE032304NL0324.

Is there any way to change the sorting methods in the Excel to the same as
in the Windows Explorer?

Thank you very much for you help in advance.

 

[Daryl S]

Dolly -

How are your files sorted in Explorer? If they are sorted by date, for
example, then your extract must include the file date, and you can sort on
that in Excel.

 

[AdamV]

How are you extracting these? Using VBA in Excel or just a command line
dump out to a text file?

 

[Nick Vivian]

Hello,

I just extract a list of file names from a folder to an excel file. However,
the sorting method in the Explorer is different from that in Excel, but I
need print both of them in the same order. I need the excel files to check
the copies printed from the files in the folders. There are handreds of
files. The file names contain both number and letters, such as:
DE032304NL0324.

Is there any way to change the sorting methods in the Excel to the same as
in the Windows Explorer?

Thank you very much for you help in advance.

check this out:
http://excelexperts.com/VBA-List-Files-In-Folder
- then you can sort how you want.

 

[herochenna]

Visit www.ExcelGoodies.Com