Ask Your Question

how can I run a macro at regular time interval? [closed]

asked 2012-08-27 17:39:54 +0100

anonymous user


how can I run a macro at regular time interval?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-17 20:45:13.494317


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 gravatar imagetohuwawohu ( 2012-08-28 06:49:36 +0100 )edit

2 Answers

Sort by » oldest newest most voted

answered 2012-08-28 03:30:56 +0100

m.a.riosv gravatar image

updated 2012-08-28 03:32:33 +0100

You can find some information here.

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.

edit flag offensive delete link more


JohnSUN gravatar imageJohnSUN ( 2012-08-28 08:47:23 +0100 )edit

answered 2012-08-28 22:56:05 +0100

Engelion gravatar image

many thanks for your help

edit flag offensive delete link more

Question Tools


Asked: 2012-08-27 17:39:54 +0100

Seen: 2,425 times

Last updated: Aug 28 '12