Get the clipboard : timer ?

[Gloops]

Hello everybody,

I use a macro to transmit the contents of the selection to a program that was written in VB6.

I meet a problem : whereas this works quite fine from Excel, from Ooo (Calc) it seems the clipboard remains locked, and the external application cannot get the information from it. It works if I close the external application and launch it again directly with a Windows shortcut, but this is not that handy.

If I execute the code step by step, it works fine.

So, I imagine a good idea could be to launch the external application from a timer, rather than from the macro that copies the information to the clipboard : that could let time to release the clipboard (the CloseClipboard API does not do it).

So, where do I find the steps to create a timer in Ooo ?

[Gloops]

Well,

I kept on trying ...

For sure the timer will be useful in some circumstances.

For this project, it appeared the clipboard is unlocked after about ten seconds, is any program called afterwards or not.

I obtained the attended result by modifying the target program, so that it waits for the clipboard reading to be successful.

Any hint about getting the clipboard closed quickerly ?

Thanks in advance.