Pop up warning when opening Excel

[Even]

Hi,
I have made an Excel file that me and my colleagues use, and I have created a pop up message asking if you are using the newest file. It is based on the current month. However, is it a way to create a warning pop up message if a user opens up the file for the previous month?

Thanks,

Even

 

[Micron]

What is based on the month - the file name? If so, is it consistent for all months? Then use Mid or Left or Right functions to compare the date part of the name to the month part of the date; if text based month name, perhaps
Left(thisworkbook.name,3) = format(month(date),"mmm")

Note: just tested and Month(Date) returns 2. Format(Month(Date),"mmm") returns "Jan" which is odd. Rather than continue on a path that might not fit your requirements I'll just post the suggestion and see if I can figure out why for my own edification. Maybe your file name contains numbers for dates anyway.

 

[Micron]

Figured out why I'm getting Jan with that (and how to get the month name), but will await your info re how you're naming the files.

 

[Even]

Thanks for your reply. The name of the file is the same each month. We just save it in a different folder for each month. The name of the month is in cell A2.

 

[Even]

But maybe it's best to change the name of the file for each month???

 

[Micron]

I'd have filenames like myWorkBook02162022.xlsm, all in one folder if at all possible. My habit is no spaces or special characters in any object, and that includes folder names. Just makes for easier coding. If you thought it still necessary, you could check the month portion of such a name and compare it to the present month but your message won't show in the current month regardless of what year it is. You might want to compare year and month if reading file names with dates.

However, I think you're suggesting that none of this would be necessary if the filename contained the date as users would know which file to open. I'd agree with that, but you know how people can be.