Blog Entry
Szukaj
Shameless Plugs
Most Popular
Who's online
Online users
User login
6355
OpenOffice.org and Excel VBA Macros
You have to love a guy like Michael Meeks. Widely renowned for his bare-bones blog style, Michael is also the foremost contributor to OpenOffice.org outside of the maintainers at Sun .
One of Michael’s latest areas of endeavor is getting Microsoft Excel VBA macros to execute in OpenOffice Calc.
This screenshot shows a fairly geeky example of a hypocycloid generator. The generator uses a VBA macro, shown lower left, to generate source values from the positions of three interactive sliders on the left near where it says “Parameters.” The data is dumped into the table at the far right. Another macro chews up the data and spits out the hypocycloid graphic. Still more macros allow you to click through some pre-set values, generate random values, and so on.
The point, however, is not what the example macros shown here do. The point is that they are Excel macros correctly doing work in Calc.
Want to contribute? When I talked with Michael at GUADEC, he said that he doesn’t have enough real world Excel macros to test against.
So if you have a good example, send it my way and I’ll send it to Michael in his secret OpenOffice.org laboratory.
I’m thaeger at that novell dot com place.
Related Articles
User Comments
Is there also VBA for
Submitted by Perry (not verified) on 12 February 2007 - 6:02am.
Is there also VBA for sWriter available?
- Be the first to comment! To leave a comment you need to Login or Register
Perry: The team focused
Submitted by Ted Haeger (not verified) on 12 February 2007 - 10:15am.
Perry:
The team focused specifically on Excel macros, since we found that that was where VBA macros were the most elaborate (meaning hard to re-create) and necessary (meaning customers had line-of-business dependencies). I don't know whether the team ever plans to attack Word macros.
--Ted
- Be the first to comment! To leave a comment you need to Login or Register
2