How do i open excel file from the prev month?

[SIM_JUN_HUI_BERTRAM_CSOD]

Hey guys, im working on a project to open excel file from the previous month so for example this month is “June” i will open “May” excel file. Currently im just opening a excel file from “April” for now but im not sure how to open the previous month for the future use. I dont want it to manually change the excel scope opening location…pls help

This is an example of the files from last year so i want to open the previous month after the start of the month

[Bogdan_Eusebiu_Siritanu (Bogdan Siritanu)]

Hi, assuming that your files will always have the month in their name (JAN, FEB etc) as seen in your example, here is one way to do it.
example.zip (93.6 KB)

[SIM_JUN_HUI_BERTRAM_CSOD]

omg thank u so much it help me !!