Open the latest file in a folder, and the second latest - up till the tenth latest saved

[nikolajfh]

Hi guys.

I have a problem that I really hope somebody can solve.

I need a macro that can open 1 of the 10 latest saved files (XLS, XlSX, XLSM) in a folder.

For example if I need to open the third last file, I would like to able to write that or choose a cell in the workbook wich would give me the information, so the macro knows wich file it should take.

I have the macro for opening the latest saved file, which I search the internet for. But I cant find anything to solve my current problem.
open-the-latest-file-in-a-folder.xlsm

I hope it's possible and someone can help me

[patel45]

Please Login or Register  to view this content.

[nikolajfh]

Thank you so much, this works! I just have a problem changing wich file to open, how do you chance from 3 to 5 or 7?

[patel45]

Please Login or Register  to view this content.

[nikolajfh]

Thank you!
There is still a little problem. It can not open from other months than the current.

I have a folder with files from every week: week1.xls -> week24.xls

If i change the numfile to 5 or 10, it just takes the first file from this month week23.xls.

But it works from numfile 1 to 3, I just need to go further back.

[patel45]

it's not very clear for me

[nikolajfh]

If you have a folder with files from previous months, you can try it out and see?

[patel45]

I think so

[nikolajfh]

If set numfile to 5, it will not take the file that is the fifth newest. it takes the first file from this month.

[guydixon]

Hi There,

Hoping that anyone can help me

I'm trying to extract the second latest file within a folder, without generating the two lists as the script above does.

I'd just like the macro to open the second latest file - can this be done?

Many thanks!
Guy

[Leith Ross]

Hello guydixon,

In the future, please start a new thread. You are not supposed to post a new question in another person's thread. Include a link to the post in your question.

Here is a macro to extract the latest Excel files (.xls, .xlsb, .xlsm, ..xlsx) from a folder. There is an example macro to open the second latest modified Excel file in the folder.

Please Login or Register  to view this content.

Example to Open the Second Latest File

Please Login or Register  to view this content.