Cool Solutions and Excel VBA Macros


July 3, 2006 3:42 pm





Hypocycloid VBA Macro ExampleYou have to love a guy like Michael Meeks. Widely renowned for his bare-bones blog style, Michael is also the foremost contributor to 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 laboratory.

I’m thaeger at that novell dot com place.

0 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 50 votes, average: 0.00 out of 5 (0 votes, average: 0.00 out of 5)
You need to be a registered member to rate this post.

Categories: Uncategorized


Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.


  1. By:Perry

    Is there also VBA for sWriter available?

  2. 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.