application.ontime

Hey all, So I'm coding a program which I want several macros to run about every hour of the day. With my current implementation it works rather often but on a few occasions I'll come into work and notice that new day has not triggered. This happens about once a week without pattern (fails on...

Hello everyone, new guy here. I'm pulling my hair out as I cannot figure this out, no matter how many threads I read on it or tutorials I watch. Here's how this one works. On open, the app checks a location on the drive for a file of the same name. If its there, the workbook closes. If it's...

I have this code in Workbook module: Sub MESSAGE1() msgBox "Change" End Sub Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) Application.OnTime Now + TimeValue("00:00:02"), "MESSAGE1" End Sub After 2 seconds it says that there is no such macro Message1. What did I...

Hi My code autosaves a workbook every 10mins. Problem is, the workbook keeps opening once it is closed. Here is my code: Workbook Application.OnTime Now + TimeValue("00:10:00"), "savethis" Module1 Sub savethis() Application.DisplayAlerts = False ThisWorkbook.Save Application.DisplayAlerts =...

hi I would like to cancel / kill the "application.ontime" on exit of the workbook Application.OnTime Now + TimeValue("00:10:00"), "savethis" the workbook keeps reopening once I close it Appreciate the guidance cheers

DON'T MIND MY SLOPPY CODE I'M JUST WINGING IT! ha OK so here is my problem...I have a worksheet that displays production data on a TV monitor in the production office. This worksheet is generated by iHistorian tags and i have it set to update every 3 seconds (so we can see when equipment goes...

Hi everyone! Using Excel 2010, Im looking for the best way to present data from e.g. sheets 1-6 on sheet "main", one sheet at a time with a time range in between using Application.OnTime. Right now im just using copying and pasting ranges using VBA in between the time ranges. (I dont have...

Thanks in advance for any help provided. Hello, I am kinda of a newbie who has learned everything I currently know about Excel VBA through Google. I have now reached a state where I don't know how to ask Google what I want. So..... I am trying to run a Logsheet spreadsheet which calls DDE...

Hi I wrote a specific Sub that does out a calculation, and I want that sub to run once every minute (automatically AKA without having to manually click the routine). how can I do this? I know its something involving Application.Ontime but not sure how to write out the code for this. Any help...

Hi All, I am working on an excel project where I have multiple pivot tables in a report attached to an external source cube of data. The pivot tables in the workbook take about 45-60 minutes (blocking the usage of other excel sheets) to go through a total refresh of the data given the level of...

Below is a script I'm trying to use to stop the Application.ontime "nextTick" macro I have running. Public Sub StopClock() 'Cancels the ontime event StopclockEG On Error Resume Next Application.OnTime NextTick, "stopclockEG", , False End Sub ------ The script is not stopping the...

Hello, I have a spreadsheet that gets live financial data. I have 3 columns (A, B & C) that are updated using some formula from this streaming data. I would like to copy the values (not formulas) of columns A & C every 5 minutes, transpose them and paste them in 2 separate worksheets (e.g...

I found this code on a spreadsheet at work (a board displayed on a big screen which is on 24/7). Can't get an answer from the owner regarding what exactly it does. It suposedly saves the workbook (amongst other actions) by calling the "UpdateData" Sub at a determined time. I find the first...

Hello!!, Sub Timer() Application.OnTime TimeValue("12:08:00"), "a" Application.OnTime TimeValue("12:10:00"), "b" End Sub Sub a() Workbooks.Open Filename:="Z:\abcd" End Sub Sub b() Workbooks.Open Filename:="Z:\efgh" Call Timer End Sub my problem is using the macro..the day i run the...

Hi everyone I've been working on a user form which some staff at work have asked for. I looking to create an event form so that staff members may type in text box, the name of the event, then enter a time in a DTPicker for the time the event is due and then set a time for how far in advance...

Hi there, I am trying to write some code that will refresh an unknown about of Pivot tables every 30 seconds. The Pivot tables are on different worksheets but all are in the same workbook. the name/numbering (PivotTable1,2,3) of the pivots are not contiguous. I have just started with VBA...

I am using Excel 2007 in a pretty atypical way. I have an ActiveX plugin that allows me to communicate with an industrial device. It allows me to query the device and receive an array of data back. This is working well. My application is pretty simple: I send a couple of values to this device...

I have a workbook with multiple buttons. Each button opens up a separate form. Also, I have a macro run in the background every minute or so using: Application.OnTime My problem is, when a form is visible and the macro runs in the background I get an error. So as a workaround I added a...

I have tried to make the following 'sleep' code operate. It did once, but not now. What am I doing wrong? Public dtBaseEventTime As Date Public Sub Main() dtBaseEventTime = "00:00:05" Again: SleepBaseEventTime GoTo Again End Sub Public Sub SleepBaseEventTime() MsgBox...

I want to preface my question by stating that today is the first I had heard of Application.OnTime. I tried viewing previous posts but I cannot get it to work no matter what I try. I have tried entering it as a PrivateSub but don't know what that means and cannot find it when looking for it. I...