How do i open excel file from the prev month?

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

image

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

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)

omg thank u so much it help me !!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.