Re: Filesearch returning files not in alphabetical order?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: General (pakman36_at_aol.com)
Date: 02/23/05 

Date: 23 Feb 2005 00:25:38 -0800

Thanks everyone.

I ended up parsing the full filename, so in the second column of the
array, I had just the filename.

Then I dumped the array into Excel and sorted by the filename, and then
rewrote everything back into the array. It only took about 1 minute to
do that portion, start to finish, for 35,000 files.

It's REALLY annoying though that the filesearch doesn't really
alphabetize. That's a pretty important detail to screw up - esp since
there's a specific option to sort by filename...Maybe MS will give me
my $$ back? :)

Thanks for everyones help.

Phil

Relevant Pages

  • Re: Help end the testing tedium please
    ... When you call it from Consolidate ... Please assume that both the filename and the ... worksheet name are sequential. ... the file really were test1 thru test60, would the array statement need ...
    (microsoft.public.excel.programming)
  • Re: Help end the testing tedium please
    ... When you call it from Consolidate ... Please assume that both the filename and the ... the file really were test1 thru test60, would the array statement need ... With Selection ...
    (microsoft.public.excel.programming)
  • Re: (Steve) Iterate files to determine latest and then kill others
    ... Declare an array to hold filenames ... Filename = Dir$ ... declare the array as long instead and stuff it with the rightmost ... > 'Get version number of main ppa file ...
    (microsoft.public.powerpoint)
  • Re: request for code review
    ... > changing the size of the array. ... char large enough to hold the LONGEST FILENAME STRING that the ...
    (comp.lang.c)
  • Re: request for code review
    ... > changing the size of the array. ... char large enough to hold the LONGEST FILENAME STRING that the ...
    (comp.lang.c)