[Solved] How to Terminate Office from a Macro

[aussiedaddy]

I need to write a macro that will run and then terminate Office. The rest of the macro I can get working but not the termination bit. I gather that terminate() is the required method and that it is provided by the com.sun.star.frame.XDesktop interface. I tried the following:

desktop = createUnoService("com.sun.star.frame.XDesktop")
desktop.terminate()

Can anyone out there help? I am obviously doing something wrong.

The error message I get is:

BASIC runtime error.
Object variable not set.

[aussiedaddy]

Hi all

Having struggled for quite a while with this before posting the above I came across some information on StarDesktop and

StarDesktop.terminate()

seems to be the solution.