ontime

Hi All, I've discovered recently that DoEvents doesn't yield to all events - for instance, OLEDBConnection objects do not update whilst VBA code is running when their state has been changed during a .Calculate call made from VBA, even if followed by a DoEvents loop. Aside from using scheduled...

Hello! I'm really hoping someone can help me. I have searched and searched and I cannot find a solution that works for me. Our network at work has an issue that when we share an excel file, if anyone on Windows 7 (most of us are on XP) opens the file, it will automatically unshare it. So, we...

Hi. I am using Excel2010. My sheet displays values collected from a database via an AddIn. The values are updated by pressing CTRL+G (AddIn function). I have an OnTime macro running SendKeys "^G" to update the values every minute. When the values exceed a certain limit, a sound is played from a...

Hi All, I want to schedule a report on a server PC that is always on. The vba code has to pick up the file and save it, if available, from 05.00 till 08.00. Every day automatically. If the file is not available the macro should re-run every 30 minute till the vba get the file or 08.00. I wrote...

hey, I am Familiar with the .ontime function to recalculate a macro every x minutes, but is there a similar function that will work to recalculate a function instead of a macro? I have a function that pulls info from a website, but the website is always changing and i'd like it to check for new...

So I get and can store public variant/double to use to start/stop an OnTime routine. How do you stop 'Application.OnTime' if you were to lose that variable due to a code execution error? Am trying to refresh a connection to an accdb file every 5 seconds, if it crashes, won't it just continue...

Hi I believe I know the answer to this but I need to be absolutely sure before testing on bloomberg terminal. Bloomberg method RefreshAllStatic data doesn't suspend execution therefore any code called directly after this method is called is likely to be executed before the refresh is complete...

Is there a way to set priorities to macros; that is, can I set a priority on one macro to force it to finish before a command button will trigger another macro? to further complicate things, I'm using the OnTime command to cause a program to loop itself until a flag gets set by a command...

Hi, I've just started using Application.OnTime and find that it works 99% of the time to trigger an event at a pre-defined time. However, the few times it doesn't work does cause issues. Can anyone explain why this is or any suggestions/comments on work arounds? Thanks, Jack

Hi All, We have a spreadsheet where live financial market data is streamed on one tab [Sheet1]. On a separate tab [Sheet2], the user can setup trigger alerts that send an e-mail if the trigger criteria is true (e.g. if Sheet1!J20 > 10000000 then send an e-mail). The user can set cell-specific...

Hi All, I hope you can save me today. I am trying to run http://www.ozgrid.com/Excel/run-macro-on-time.htm in excel 07 but I can't seem to make it work and I am ready to cry. In Thisworkbook code I have the following: Private Sub Workbook_Open() Application.OnTime...

Hello All I was hoping one of you kindly experts would help resolve a problem for me, or at least point me in the right direction, please. I have a macro that is set to start at 7:59 am every day. I have used the: Application.OnTime TimeValue("07:59:00"), "Mymacro" Code for this. The macro...

Hey all. I wrote a macro that goes to the internet and into my Yahoo! Finance imports the entire page, searches for the word portfolio value, goes down one cell to grab that value, brings it back to a data worksheet and deletes the imported data. I am trying to set it up so this program runs...

Greetings, I've searched the board and this question has been raised before however, unless i overlooked it, no solution has been provided for the two following main problems caused by having a running clock in a worksheet cell : 1-Clock stops updating while excel is in EDIT MODE 2-Excel...

Hi. I have used a few ontime events in a sheet that call a macro when time is reached as stated here. I have noticed that, even if you close excel, the ontime vars are still stored and, if I re-open the file and change times in cells which are referenced from the ontime statement, some strange...

Hello all. I would swear that I have seen this kind of syntax for ontime somewhere: Application.OnTime TimeValue([A1]), "colorbg_macro" But if I try to use it, a Type Mismatch error 13 appears. If I use a real time value like next one the function works: Application.OnTime...