VBA to Schedule Running of Macro Based on Current Time and Environ ("username")

[bepedicino]

I am looking for some VBA that will run a macro at a specific time based on the current Environ ("username") and system time.

Time Table

User 1 = 5:00 pm
User 2 = 5:15 pm (current user)
User 3 = 5:13 pm

For example, if User 2 is the current user then the macro will only run at 5:15 pm and the users and times will be ignored.

 

[gruntingmonkey]

Do you realise that this will only work if a user is logged on and has the specific workbook open at that particular time?

 

[bepedicino]

Yes, gruntingmonkey I do realize that; it will not be an issue for what I am trying to achieve. In actually, that is exactly what I want it to do.

Do you realise that this will only work if a user is logged on and has the specific workbook open at that particular time?

 

[bepedicino]

To clarify, the macro should meet two criteria in order to run; both the Environ$("username") and the current time will need to be true. Anyone have a suggestion?

If Environ$("username")=David then
run macro1().with 16:45:00
End if

 

[gruntingmonkey]

Only a few months out of date....

This explains how to do this just in case anyone is looking.

https://www.mrexcel.com/forum/excel-questions/48654-running-macros-specific-time.html