#1
|
|||
|
|||
Naming files in folder, DOS vs Windows Explorer ASCII sequence
I converted excel sheets to text files. I tried to name output files as
FileName = "C:\Users\VBA-beginner\Table_" & x & ".txt" This will apply to WORD VBA as well. Problem is sorting for humans and ASCII order used by computers is different. My file opened were in the order Table_1, ...10, ... instead of Table_1, ..2,...3,. I needed files to be saved in a certain sequence, the human order. Using windows explorer, the files appeared in human order, but using the F8 debugger, I found our sequence was different order. When I opened DOS window and used the dir command, it displayed ASCII order, which is how files get opened with VBA. See blog for further explanation http://blog.codinghorror.com/sorting...al-sort-order/ Only solution is to use trailing zeros. So here is my fix with leading and trailing format: 000_Table_000 001_Table_001... x = Format(i , "000") FileName = "C:\Users\VBA-beginner\" & x & "__Table_" & x & ".txt" Last edited by equalizer88; 08-12-2015 at 03:20 PM. Reason: Generic username |
#2
|
||||
|
||||
Your content doesn't have trailing 0s, it has leading 0s. That said, if you want to control the sort order of files whose name begins with 'Table', you can use:
x = Format(i , "000") FileName = "C:\Users\VBA-beginner\Downloads\RPYC\CASS-Tables\Table_" & x & ".txt" These files will have the same sort order as: FileName = "C:\Users\VBA-beginner\Downloads\RPYC\CASS-Tables\" & x & "__Table_" & x & ".txt"
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Macropod,
Yes, you are correct about only needing the leading numbers. I just did it for effect, easier to read. That could confuse people, so your solution is the correct one for the forum. Thank you. |
Tags |
batch save, filesort, naming files |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
File lists like windows explorer in onenote? | karmajohn | OneNote | 0 | 07-22-2015 02:24 PM |
Windows Explorer search function | S Fierro | Windows | 1 | 07-11-2014 06:11 AM |
Personalize windows explorer | dianabanana | Office | 1 | 03-24-2014 08:10 PM |
How to enlarge Thumbnail View in XP Windows Explorer | Gary Drumm | Windows | 3 | 02-10-2014 02:25 PM |
Windows explorer search problem...help!! | NewSysAdmin | Windows | 1 | 03-08-2011 05:33 PM |