Hi Jim, On 1/4/06, Jim Wright <[EMAIL PROTECTED]> wrote: > This thread got me thinking about finding out how easy it is to write > a macro in OO...unfortunately I'd say the answer is "not so easy". I > can definitely see the power of OO's object oriented model, but I > think a lot of people who use Excel macros heavily would balk at > it
>From someone who has migrated from Excel VBA to OO.o UNO, I agree with your point. OO.o's macro is not very intuitive, at least at first especially for someone with a heavy VBA background. In defense of OO.o, though, I must say UNO is much more powerful than VBA, except that its documentation is not very abundant. And you can't learn it just by recording a macro and study the generated code. The Novell folks are actually working on implementing a VBA layer atop OO.o's existing object model. http://wiki.services.openoffice.org/wiki/VBA But again, 100% compatibility is always a tough goal (read: impossible), so even this will not replace the need to learn OO.o's object model in the long run. Kohei -- Kohei Yoshida OpenOffice.org Calc Hacker http://kohei.us/ooo/ -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/
