Hi,
I experimented in a test machine with Excel running the following commands in ThisWorkbook.Open of a workbook:
Application.OnTime TimeValue("01:35:00"), "Module1.Open_Files"
Application.OnTime TimeValue("01:50:00"), "Module1.Save_Close_Files"
Application.OnTime TimeValue("01:58:00"), "Module1.Close_App"
I read that in order to cancel these commands I must write exactly the name and the time of the procedures with Schedule Cancel:
Application.OnTime TimeValue("01:35:00"), "Module1.Open_Files", , False
Application.OnTime TimeValue("01:50:00"), "Module1.Save_Close_Files", , False
Application.OnTime TimeValue("01:58:00"), "Module1.Close_App", , False
My question is about the time: During my testing I used various time values, for example, 04:50, or 5:12 etc. Of course I don't remember all the time values I used. Will they remain active in Excel? I know that they remain even if Excel is closed and opens again.
Does Excel keep these actions after reboot of the PC?
In any case, how do I get rid of the multiple time values I used? Additionally, how can i check what OnTime actions are active for an Excel file, or for Excel itself on a specific PC?
Thank you
I experimented in a test machine with Excel running the following commands in ThisWorkbook.Open of a workbook:
Application.OnTime TimeValue("01:35:00"), "Module1.Open_Files"
Application.OnTime TimeValue("01:50:00"), "Module1.Save_Close_Files"
Application.OnTime TimeValue("01:58:00"), "Module1.Close_App"
I read that in order to cancel these commands I must write exactly the name and the time of the procedures with Schedule Cancel:
Application.OnTime TimeValue("01:35:00"), "Module1.Open_Files", , False
Application.OnTime TimeValue("01:50:00"), "Module1.Save_Close_Files", , False
Application.OnTime TimeValue("01:58:00"), "Module1.Close_App", , False
My question is about the time: During my testing I used various time values, for example, 04:50, or 5:12 etc. Of course I don't remember all the time values I used. Will they remain active in Excel? I know that they remain even if Excel is closed and opens again.
Does Excel keep these actions after reboot of the PC?
In any case, how do I get rid of the multiple time values I used? Additionally, how can i check what OnTime actions are active for an Excel file, or for Excel itself on a specific PC?
Thank you