I need a macro msgbox to run automatically on the last day and first day of the month. I have been researching this and cannot find anything on it. Please any help is appreciated.
I need a macro msgbox to run automatically on the last day and first day of the month. I have been researching this and cannot find anything on it. Please any help is appreciated.
Do you know how to calculate the Last Day of the Month? Did you want it to run when your application is launched or at some other time?
Yes I know how to calculate the last day of the month. Just don't know how I would write that up in a code. My macro is named EOM.
When were you planning to to make the date check, in the AutoExec macro?
sorry, the application should be up and running on those dates when the msgbox is launched.
yes in the autoexec
Do you have a timer event running constantly somewhere?
No I don't. I am fairly new to all this so the only thing that I have created so far is the msgbox macro. This is the last thing that I need to finish off my database. If you could help me I would really appreciate it.
To recap: your application will be started each day and you will check the date in the AutoExec macro, right? Is there a possibility the application will *not* be started on these two days? Does it need to do something different for the 1st vs the last day of the month?
Correct. The application is run everyday. Now I don't want the message box to appear all day long. So once the msgbox is clicked to remind the person to do what they are suppose to do those days it should not reappear correct? Even if the app is closed and opened up again?
You will need a way to record whether you have shown the message for that day as well. What did you have in mind for that issue?
don't know. I just thought of that. Like I said I am extremely new to all of this and coding is not my thing.
How about the answers to the other two questions as well?
the application will not always be up and running. It does not need to do anything different on those 2 days.
So you will be doing the same thing on *both* the last and first day of the month or do you just need to do something once a month so you picked either the first or last day as an example?