Sorting in Excel like in Window Explorer

  • Thread starter Thread starter Dolly
  • Start date Start date
D

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.
 
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.
 
How are you extracting these? Using VBA in Excel or just a command line
dump out to a text file?
 
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.
Click to expand...

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