Modification to the Newest file in a folder function - Getting a list of 'n' Newest files

[yoursamrit2000]

Hi All,

I have been successfully able to use the Newest File Function to locate the newest file in a given folder. Here is how I use it:

Please Login or Register  to view this content.

What I want help with is, to get a list of 'n' number of latest file.

Idea being the macro downloads a list of CSVs in a list. I use a code to import those files to the active workbook. Doing it one by one is obviously time consuming. Hence, trying to get a list of all those 'N' number in files.

Please Guide.

[dangelor]

Possibly...

Please Login or Register  to view this content.

[yoursamrit2000]

The code breaks into an error at the line:
Set Arr = CreateObject("System.Collections.ArrayList")

-2146232576 - Automation error

[dangelor]

I've used an Array List many times without a problem... Found this with a google search

VBA ArrayList Automation Error
You may encounter the VB Run-time Error ‘-2146232576 Automation Error’ when trying to get the ArrayList to work. Or sometimes your code has been working for a long time and then suddenly this error appears.

This is caused by not having the correct .Net Framework version installed. The correct version is 3.5. It doesn’t matter if you have a later version like 4.7, you must have 3.5 installed.

If you can't correct it, let me know and I'll try a different approach.

[yoursamrit2000]

I Will be able to download the file and install it, but since the file will be shared with other people, there is a chance that they might not have .net 3.5 installed. Hence, I droolingly ask if some another approach can be used. Thanks in advance

[dangelor]

Not Tested...

Please Login or Register  to view this content.

[yoursamrit2000]

That does it, however the function quicksort gives me the oldest files. What would be the way to reverse the sorting order?

[dangelor]

Please Login or Register  to view this content.

[yoursamrit2000]

Thank you ever so much Dangelor, you are a star. Sometimes, answers are much simpler than one thinks them to be.

I was trying to reverse the sorting order, forgetting your approach could be done.

I appreciate your time and effort in this.

Marking this thread Solved

[dangelor]

Glad to help and thanks for the feedback!