application.ontime

I wrote a macro AutoPing() that allows to loop itself every 5 minutes. It works between before 23:50. But it gets error when it passes to next day (00:00). Please help me solve this error. Thank you.

Hi All I have been researching how to resolve my Application.OnTime issues with regards to my VBA code but have not had any luck. My code does not execute at all. I am not experienced with VBA, but simply want my workbook to save to a drive 4 times a day. Thus, I have the below code repeated...

This is a continuation of a post that is now buried. Application.OnTime continuously opening my workbook The Code @AlphaFrog helped with is working perfectly. Each instance of save, the workbook comes to the foreground and then to the background again after the save is completed. While this is...

found a post, Application.ontime DateValue ???, that showed how to set a specif day of the week for an application.OnTime to run, but cannot get it to work for my file. I want my macro to run every Friday @ 9:00AM but nothing happened when I changed the values to today in order to test. Can...

Morning/Evening all i have the below code set to update the data in a file every 5 min but it is running the Update sub twice one immediately after the other. i do not have the code (Application.OnTime mTimerTime, "my_Procedure") anywhere else in any other subs so im a bit stumped. where am i...

Hello Frinds i want to make some changing in my account. i want if bu8<>0 then it copy the value of selected range from sheet 1 to sheet 2. i don't know about vba. my friend says me it will be by event change in my main updatedata but i don't know how to write code for it. as you can see that...

Hello guys, I'm trying to setup a timeout for a macro I'm creating, it reaches out to a file, if that file is open it times out for 10 sec and then tries again. My initial approach was to make a do loop for x seconds, but that was an awful idea because it prevents other actions from happening...

RE: Stopping macro execution without generating an error message.... This code displays a userform every 5 seconds t = Now() + TimeSerial(0, 0, 5) Application.OnTime t, "RepeatMSG" And the macro which displays the form: Sub RepeatMSG() Userform.Show t = Now() +...

This code Private Sub cmdFindDate_Click() Dim i, n As Integer Dim t For i = 2 To [A65536].End(xlUp).Row n = Day(Cells(i, 1).Value) If n = Day(Now()) Then t = Now() + TimeSerial(0, 0, 10) Application.OnTime t, "RunNewSetMSG" Else MsgBox "value...

Hi everyone. I have this command "Application.OnTime TimeValue" on my workbook while it is open. I just like to know if that command will continue it's assigned task based on the time given on everyday basis or just the day that the workbook is open? Thanks Application.OnTime...

<tbody> I wonder if any members of this forum could kindly help me with this problem? In my spreadsheet, cell DD4 has a countdown timer running, linked to a website, and the timer runs down to zero 00:00:00, and then continues past zero with a negative sign, e.g. -00:01:00 after one minute...

Dear, I have a macro which has been working for long time under Windows 7 and Office 2010; however, when migrating to Windows 10 and Office 2016, it stops working. I am wondering if the forum can assist me to identify the problem. The first part deals with the execution at opening the workbook...

Hello, How can we change the below code function. Istead time I need a timer... Once userform pop ups timer will start. Thanks Option ExplicitDim Tempo As Date Sub clock1() Tempo = Now + TimeValue("00:00:01") Application.OnTime Tempo, Procedure:="Lable_Text", Schedule:=True End Sub Sub...

I subscribe to a service that sends real-time updating stock prices directly to my spreadsheets. (Hoadley Financial Add-Ins for Excel.) Using various posts on this site, and much trial and error, I cobbled together a little VBA code that monitors these stock prices and notifies me when my open...

I have a timer once my workbook opens, after one minute aUserform pops up, and asks if you are still using the file. If you hit yes, theoriginal timer resets but if you hit no the workbook closes. However, when theuserform pops up a second timer starts, when this timer times out it closes...

I have the following code in my modules. It works great, for what it was intended to do. (Keep a running clock for scheduling purposes, break meal penalties etc) The issue arises if you have two copies of the file open at the same time. When two files with this code in it ARE open, when you...

Hi, I been researching this today but i am getting stuck. I would like to run a Sub () in my personal workbook called Sub T205 () on Fridays at 6pm eastern time. Not sure what Application.Ontime to use and where to put it into. Can I put it into my personal workbook to run that sub? Do I have...

Hi, I have a stopwatch which is working great except when a user opens a new workbook the undo function is unavailable. It becomes available again when the clock is stopped. I have the code below in a module. Does this happen to anyone else? Option Explicit Dim NextTick As Date, t As Date...

Hi, i have the following code which works great with just the one open workbook. But it runs into problems if other excel workbooks are open Private Sub Workbook_BeforeClose(Cancel As Boolean) Application.OnTime dTime, "autoSave", False End Sub Private Sub Workbook_Open() dTime = Now +...

Hi, Thinking of ways I can trigger a macro hourly without using application.ontime application.ontime can cause issues and I don't find it too reliable. My idea was to have a cell containing current time =Now()-Today() Then cells with a 1/0 flag for each hour Worksheet_Change event with if...