Hello .... I am using a simple piece of code to load text file names to a listbox. The trouble I am having is when I have to close the Excel userform, the listbox then populates the text file names in alphabetical order when the userform is re-opened. I need the listbox to load the text file names by date/time modified oldest to newest. Anyone know how to do this? I cannot seem to find an example anywhere on doing this.
Thanks in advance for any help.
See the last reply in this thread: http://www.experts-exchange.com/Soft..._22513040.html
If you integrate this code into your module and populate your list box by the Function GetFilesInDateOrder, it should list it in the appropriate order
Regards,
Rudi
Thanks, Rudi .... I can't see the code because I am not a paid member. Can you post the code?
Hi,
I'm so sorry... I did not notice this was from a site that requires subscription.
I don't want to violate any rules so I think it's best not to post code that requires unlocking from this site. However here is code from another site that could help resolve your issue with a bit of tweaking. See this page: http://vba2008.wordpress.com/2008/10...a-file-search/
Not tested.
Please Login or Register to view this content.
Hi
Not sure if the code above that I posted worked for you...?
Here is a better code block that I tested. It creates an array variable that stores the file list and modified date. You can use the variable to populate your text box with the files in descending order by date.
Please Login or Register to view this content.
Thanks RudiS and Jindon... I am playing around with both pieces of code and will report back. I am having a little trouble because I have a "Do Loop" and a "For Loop" in my code. I will post back tomorrow with my issues when I get on my other PC. Thanks again for all of your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks