Ask Your Question
0

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

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

anonymous user

Anonymous

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

Comments

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
0

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

edit flag offensive delete link more

Comments

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

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

Engelion gravatar image

many thanks for your help

edit flag offensive delete link more

Question Tools

Stats

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

Seen: 1,832 times

Last updated: Aug 28 '12