application.ontime

Morning all, I'm not a VBA pro, so you can imagine my delight when I managed to auto start a macro, that made the test in one of my cells "blink". However, the file now opens everytime I close it - because I haven't ended my Application.OnTime and I just can't get my head round it. So, in my...

Hi, I'd like to apologize in advance if the following question seems rudimentary as I'm very new to VBA. However, i've written a macro that basically just pastes a row as values for every sheet in my workbook. I would like for this to run automatically at 6 specific times throughout the day...

Greetings, I have a number of scraper like subs that I would like to automate. for this task I am using a number of subs to serve as the timing tool like the one below: Sub YZ_ST19() RW19 = Now + TimeSerial(744, 0, 0) Application.OnTime EarliestTime:=RW19, Procedure:=RWCALL19, _...

I have a clock that works off from auto refresh and works great but I have to start it off from a button. How would I change my code to automatically run when I open the workbook so I can eliminate the button? Dim SchedRecalc As Date Sub Recalc() With Sheet1.Range("A1") .Value = Format(Time...

My simple run requests were working just fine until the 2016 excel upgrade. I tried to enable and disable options but nothing seems to be working. Workbook: Private Sub Workbook_Open() Application.OnTime TimeValue(13:30:00), "Refresh" Application.OnTime TimeValue(13:31:00)...

I setup this sub to have my file backed up every 5 minutes. When I execute the module manually it works as expected but after the 5 minutes timeout I get an error message saying it cannot run [workbook path][sub name] I looked at examples on the web and I can't find what I did wrong. My sub is...

Hello Folks, I have ten timers that run at given points. 95 % of the time they work fine, but once an awhile they will fire early why is this? Here is my code. I'm I doing something wrong that allow for the once an awhile early firing? In Userform1 module Private Sub Benontimer() If...

Hi, as an example below Sub ontimer() MsgBox ("Hello") Application.OnTime Now + TimeValue("00:01:00"), "ontimer" End Sub when executed from button, displays the message then 1 minute later executes it again. Now if the button is pressed more than once, it is looping more than once. So if i...

Hello everybody. I need my macro "Test" running every day at 11:30. Writing in ThisWorkbook Private Sub Workbook_Open() Application.OnTime TimeValue("11:30"), "Test" End Sub is not a good idea: it does not work, probably because of a loop. So, I've tried to identify univocally date and...

Hi, please can someone help me? I keep getting the following error: Run time error 1004 - Method 'OnTime' of object'_Application' failed. It keeps popping up quite often but from different situations on my file but it doesn't always happen when i repeat a certain situation. Here is all the...

Hi Wile reading a book, I came across this function and I try to grasp it, yet there is something I am clearly missing. I tried to create pseudo password login. I crated a userform, added text field and login button. I added code: Private Sub confirmPassword_Click() If passwordBox.Text =...

HI, This runs a macro every 5 minutes in order to .SaveCopyAs. The master file conducts a power query from web every 1 minute. I .SaveCopyAs to another file name/location every 5 minutes. Obviously, it saves an actual copy of the master file, including the webconnection (which is set to run...

I can't seem to stop this. I need a macro that can be called to stop this code. Sub autorun() Application.OnTime ThisWorkBook.Sheets(1).Range("p31").Value, "up"

Hi, I'm looking to run Application.OnTime and specify both the workbook and some arguments. I can get them to work on their own, but not together. For example, the following code works if "MacroToBeCalled" subroutine is in the same workbook where I set Application.OnTime. Application.OnTime...

Hi all, I am using this code in a workbook to activate a timer when it is opened, then after 15 minutes make it close and save changes. my question is, if I have this workbook open, then open another the timer seems to activate on that one too, then as a iswitch between it starts the timer...

Hi there, I have a macro which I'm using to toggle an auto-save. The Sub 'Auto_Save_Record' works fine and turns on the auto-save every minute, but my toggle only works to turn the Auto_Save_Record on. When I toggle Auto_Save_Record to OFF, I get the Error 1004: Method 'OnTime' of object...

I have VBA code that reads a temperature device every minute "On the minute", displays the data in Sheet1, and saves the data to an *.csv file. I am using Application.OnTime to run the VBA code each time Seconds = 00. The problem is, I would like to allow the user to enter a message along with...

Hello The function Application.OnTime could be use to refresh or recalculate a cell with the minimal interval of 1 second. Is there a way to have the function using a 200 milliseconds interval? Martin

I am looking for a user defined function which will call a message sub routine using the application.ontime method . I am passing arguments to the function that will execute at a certain time taken from selected cell . But my function doesnt work . I dont understand why. Can anyone help me with...

I have been around the interwebs all day and found multiple posts on multiple forums about this but I cannot get it to work correctly no matter what I've tried. Can someone please tell me why my timer never stops and restarts? I start the timer on workbook open and no matter how many different...