View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Directory listing manipulation

OK, I understand better now. How do you know what is a path row and what is
a file row?

--

HTH

RP
(remove nothere from the email address if mailing direct)


wrote in message
...
I'm trying to copy the path to the appropriate row so that I can look up

the location of a file after I sort
the file names.

example before sort:

Path 1

File8 Path 1
File3 Path 1
File61 Path 1

Path2

File4 Path 2
File9 Path 2
File33 Path 2

after sort
File3 Path 1
File4 Path 2
File8 Path 1
File9 Path 2
File33 Path 2
File61 Path 1



On Wed, 8 Dec 2004 09:55:30 -0000, "Bob Phillips"

wrote:

I'm lost. Apart from moving down across and every which way, what are you
doing? What is the objective, the format of the data?