how can I run a macro at regular time interval? [closed]
how can I run a macro at regular time interval?
First time here? Check out the FAQ!
how can I run a macro at regular time interval?
You can find some information here. http://www.oooforum.org/forum/viewtopic.phtml?t=59763
But it is reachable set a regular time interval without macros.
The option Menu/Insert/Link to external data, lets to set an interval time to update the link.
You can set a link with an empty .ods, but you need to have a named range in this file, because is needed to select it to get the link.
In this way I think it is possible to trigger the macro with the update of the cell that receive the link.
Another discussion on the same topic - http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=46196
many thanks for your help
Asked: 2012-08-27 17:39:54 +0100
Seen: 2,425 times
Last updated: Aug 28 '12
Can't save LibreOffice Basic Macro in .xls file [closed]
Auto Formatting Sheet based on date [closed]
Is there an alternative to Oracle Crystal Ball for LibreOffice Calc? [closed]
Calc Macro Functionality [closed]
retrieving formula values [closed]
How do I export a chart in an image format from LibreOffice Calc? [closed]
Are there plans for a "papercut" project for libreoffice [closed]
Is it normal for Calc goal seek to take very long? [closed]
Please refine "Search" in Calc - implement functions in Gnumeric [closed]
Just an idea: Create a "master macro" that runs at application start. Once started, the master macro could call your "worker" macro in certain intervals. The interval functionality may be based on the oobasic WAIT function or on a loop that compares current time to a certain time.