Treeview - Sort Nodes Alphabetically (Like in Windows)

Hi team,

Following on from my last thread regarding populating a TreeView with windows directories, VBA has the tendency to sort the nodes in numerical order where I need to sort them alphabetically as they would appear in their windows directory folder.

Has anybody got a clue on how to do this?

Code:

---

The TreeView.Sorted = True

---

The above seems to have no effect, is there a way to stipulate how it is sorted e.g. Numerically, Alphabetically, Ascending, Descending?

As this is only my fourth post here at vbaexpress the next post contains my original thread addressing the population of my TreeView and also a link to the ready to use file in which i manipulated to suit my requirements.

I have also attached images of how it looks on my userform and how the order should look as per the windows folder.

Userform: (Sorted Numerically)
Attachment 13439

Windows Explorer: (Sorted Alphabetically)
Attachment 13440

Im using windows 7
VBA 7.1
VBA Knowledge: Beginner

Cheers,


Luke Kelsen

they are all text strings that contain numbers.

below you will find the answer:
https://msdn.microsoft.com/en-us/lib...(v=vs.60).aspx

Why don't you use

Code:

---

Application.filedialog(3).show

---

Mancubus,

As in the Nodes are text strings which each have an assigned index number of 0, 1, 2, 3 and so on.... ?

If so then how would I code it in a way that whenever a folders text string starts with a number e.g. "1 - Estimates and Proposals" that it would sort from say 1 through to 17 etc. and then in each sub-folder if there are some folders with text strings starting with being from numbers 1 through to 6 for arguments sake that it would sort those in numerical order e.g. with folder "1 - Client" at the top and so on...

Sorry my understanding of VBA is very limited and I am learning pretty much from search engines and forums such as these. Would it be helpful if I upload my Excel file?
I also wouldn't even know where to put a sort function in my code.

Apologies for the image sizes above and the link i promised which I am not yet allowed to include in my posts.

Quote:

---

Originally Posted by snb

Why don't you use

Code:

---

Application.filedialog(3).show

---

---

Sorry snb i'm not quite sure what you trying to say?

Cheers,


Luke

Just a thought, when the TreeView is populated, i'm guessing it grabs the first folder/file object in the specified windows directory, assign it index number "0" add it to the TreeView then moves to the next folder/file object in the specified directory and assign it index number "1"... and so on?

If I could find a way for the TreeView to be sorted by its index number from 0 through to X number of nodes, would you guys know if this is possible?

Cheers,


Luke

Did you run the code I gave you ??

one option can be renaming folders in desired sort order.

Quote:

---

Originally Posted by snb

Did you run the code I gave you ??

---

Hi snb, I'm not quite sure what I'm meant to do with it sorry?

Quote:

---

Originally Posted by mancubus

one option can be renaming folders in desired sort order.

---

Mancubus, the folders are already sorted in the correct order in the windows directory if that's what you mean?

No.

when sorted, the two screenshots you posted would be the same.

Your folder names
1 - blah blah
2 - blah blah
...
10 - blah blah
...
17 - blah blah


sorted folder names
01 - blah blah
02 - blah blah
...
10 - blah blah
...
17 - blah blah

Quote:

---

Originally Posted by mancubus

No.

when sorted, the two screenshots you posted would be the same.

Your folder names
1 - blah blah
2 - blah blah
...
10 - blah blah
...
17 - blah blah


sorted folder names
01 - blah blah
02 - blah blah
...
10 - blah blah
...
17 - blah blah

---

Sorry, yes that seems a much more feasible solution and such a simple one. Thank you once again!

Will have to update our entire history of projects within our file system but that's not a problem.

Cheers once again for your help gentlemen,


Luke

welcome again.

i dont know why windows explorer display in numerical order the folders whose names start with a number. even they include numbers they are strings.

Quote:

---

Originally Posted by mancubus

welcome again.

i dont know why windows explorer display in numerical order the folders whose names start with a number. even they include numbers they are strings.

---

I guess Microsoft may have programmed explorer to identify folder/file names where the string contains numbers at the start of the folder/file name, and then sort integers before text? Just a guess :cool:

Hi,

If you want to sort your treeview you should use " yournodes.sorted=true" where yournodes is the parent node of the nodes you try to sort .
If you don't have root node just use "Treeview.sorted=true"


Good luck