I'm sure you'll agree that the first step towards complete automation is the opening and closing of a spreadsheet, so let's start by seeing how OOo's UNOs can help us do that.
There are a couple of things that you need to know before you can use a service:
Each service is stored in a module.
All modules are stored within a central module—com.sun.star.
A service is created by using the createUnoService function.
We're going to be using the Desktop service, and this can be found in the frame module:
So, let's look at using a UNO in a very simple subroutine that ...