Sort files in folder vba

Once this is working I was going to try and create some user boxes to define the folder locations etc. I tried to go this way originally but did not know how to append the different file ext to the results of the HMY dir. Hi I am am new and pulling my hair out. Is there a way to sort the files in a dir? I have three folders which contain files that i wish to open.

Inty Code. Hi Totallyconfused and welcome, Assuming that the order is not important only the matching of the 3 files. Folder Dim dict As Scripting.

Add CDbl SourceFolder. Keys MsgBox dict. Item WorksheetFunction. Last edited by a moderator: Jul 24, Click to expand Microsoft Scripting Runtime should be the only reference that you need to turn on. You must log in or register to reply here. Similar threads P. Question Applied this macro to delete empty excel files in a folder.

Prasad K Oct 27, Excel Questions. Replies 7 Views Nov 8, Zot. Solved Macro to consolidate tabs from multiple excel sheet in to one excel sheet. Replies 1 Views Nov 29, siddo. Question VBA will not auto backup file if file lives in Sharepoint.

ReignEternal Sep 30, Excel Questions. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 4 years, 10 months ago. Active 4 years, 10 months ago. Viewed 3k times. Range "A:A". Improve this question. You could store the results of Dir in an array, sort this array into a new one and use this array then. R3uK How can I do that?

Please help us improve Stack Overflow. Take our short survey. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 8 years, 6 months ago. Active 8 years, 6 months ago. Viewed 5k times. Improve this question. Finch Finch 2 2 gold badges 9 9 silver badges 18 18 bronze badges.

By "in windows", I assume you mean "windows explorer", which usually sorts by name. Since that's obviously not the case here, I would suggest that it is being sorted by modification date or some other field. Without knowing that, we can't really answer your question. Might be worth noting that the way the files are "sorted" in Windows Explorer is merely the way they are displayed to the user.

FSO is returning them in a logical order.