Posted by: Anonymous Coward
on June 25, 2005 01:48 AM
I don't know about recording, I've never found that useful.
However, I've done a lot of macro writing in both OOo and MS Office, mostly for spreadsheets.
OOo has fully capable BASIC macro language. Visual Basic is easier to use, since it is more tolerant of sloppier writing, which is not really a good thing, especially in more complex situations. In OOo macros you have more need to explicitly call document objects, and you need to know something about the underlying structure in order to do that. In VBA, it will often assume what you meant and do it, only occassionaly frustrating you by assuming something unexpected.
VBA help is more mature, though I can't stand the fact that it now connects to the internet to download the help articles in "real time" - I'm too impatient to wait 15 to 30 seconds for each article and each search list to appear on my screen.
OOo BASIC and VBA are fairly compatible, but the the Object Models used by OOo are somewhat different than that used by MS Office. With research and a little editing, you can port old VBA macros to OOo.
OOo also has bindings now for Java and Python, so it actually gives the user more choices for writing macros.