Excel Help Forum - View Single Post - Recursive Function + File searching to return path

ph8 · #14 07-25-2005, 02:55 AM

Quote:

Originally Posted by Bob Phillips

"ph8" <ph8.1skiif_1122030359.6078@excelforum-nospam.com> wrote in message
news:ph8.1skiif_1122030359.6078@excelforum-nospam.com...

> I compared the code to the previous code you gave me ("the long one")
> and realized they were different. I re ran the first code, and it
> seemed like it was displaying the list in the correct order. I also
> noticed the 'long code' didn't use the .Filesearch feature. How can I
> incorporate the output of the long code to do what I want it to. I
> couldn't find a way to edit the code myself, thats the one that really
> confused me when I tried to understand it =/

That is correct. AGain, that is relatively straight-forward, the complexity
is mainly in the browse folder functionality, but if you isolate that, it is
fairly simple. What amendment do you want to make, I should be able to help
you with that. Is it just removing the hyperlinks,. or do you want the date
as well (created, modified)?

The way the code works now is it displays all the files in a hierarchy spacing the file names to show what spreadsheets are 'under' the other spreadsheets. All I need is a straight list, one column, of all the spreadsheets. Instead of putting the file names in different columns, I want the that column number (or the Tier level) in the second column. Ideally, the output should look like this:

Filename / Tier
FileA.xls / 1
FileB.xls / 2
FileC.xls / 3
FileD.xls / 3
FileE.xls / 4
FileF.xls / 4
FileG.xls / 3
FileH.xls / 2
FileI.xls / 3
FileJ.xls / 3
FileK.xls / 3

Code:

Instead of the way the code currently outputs the file, which is:
FileA.xls
|--FileB.xls
   |--FileC.xls
   |--FileD.xls
      |--FileE.xls
      |--FileF.xls
   |--FileG.xls
|--FileH.xls
   |--FileI.xls
   |--FileJ.xls
   |--FileK.xls