ontime

  1. J

    Ontime vba schedule on server

    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...
  2. J

    vba .ontime

    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...
  3. ClimoC

    Application.Ontime question (losing variable during runtime)

    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...
  4. Jon von der Heyden

    Sleep API vs OnTime

    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...
  5. J

    Setting macro priorities & Ontime command

    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...
  6. J

    OnTime problem

    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
  7. D

    What's the impact of running a Macro all day?

    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...
  8. caritx

    Run a Macro at a Set Time

    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...
  9. R

    Timed Start Macro Repeat Problem

    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...
  10. D

    Daily Automation a VBA Web Query

    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...
  11. Jaafar Tribak

    Problems with running Clock in worksheet cell

    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...
  12. L

    Stop / reset all ontime events

    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...
  13. L

    How to use cell reference for TimeValue in VBA

    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...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top