OpenOffice is a wonderful project that wants to provide the world with a free, open-source office suite. This is a wonderful idea and this project nees all the help they can get. I was trying to use the Basic interpreter to enhance a spreadsheet. This proved to by quite tough since the Basic Documention could be better. I don't have the time to help improve the documentation. Instead I simply provide the Basic Macro here, so that other people can find it on the web and use it as an example.
The API can be usefule too. Especially the part about the spreadsheet interface.