Macro to open latest file within a folder

Hi Guys,
I have case where there are excel files arranged like this within a folder. For example:-

XA11_df01.xlsx
XA11_df02.xlsx
XA11_df03.xlsx
.
.
XB11_df01.xlsx
XB11_df02.xlsx
.
.
YA11_df01.xlsx
YA11_df02.xlsx
.
.
YB11_df01.xlsx
YB11_df02.xlsx
.
.

All these files are located in one folder. I want to write a macro to open the latest excel files based on lastmodified date and time for each file name like XA11, XB11, YA11, YB11. I only want to do this for excel files (".xlsx") within a folder as there are other pdf files also in the folder. I want macro to open the latest file for first file name run my code on it , then open latest file for second file name and run my code on it so on.


Any help will be highly apprecited.

Thanks.
Roop

Hello Roop,

This macro will open the most recent ".xlsx" file in the given directory based on the file name to left of the underscore. You will need to change the file path and add a call to your macro in this one. At the bottom you will see a comment (in bold text). This is where you need to add the call.

Please Login or Register  to view this content.