Another discussion on the same topic - http://user.services.openoffice.org/en/forum/viewtopic.php?f=20&t=46196
JohnSUN ( 2012-08-28 08:47:23 +0200 )edit
asked 2012-08-27 17:39:54 +0200
Anonymous
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
JohnSUN ( 2012-08-28 08:47:23 +0200 )editmany thanks for your help
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-08-27 17:39:54 +0200
Seen: 141 times
Last updated: Aug 28 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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.
tohuwawohu ( 2012-08-28 06:49:36 +0200 )edit