Cool Solutions

VBA Macros Update


August 19, 2006 12:22 pm





OpenOffice IconAs I previously mentioned in my post about VBA macros, you gotta love a guy like Michael Meeks. However, I’ve recently learned that you also gotta love Novell’s Noel Power, since he’s doing much of the work at Novell on VBA macro support in the Novell Edition of The amount of work these guys have already done will go a long way to improving OpenOffice. That is, of course, dependent on if/when this massive code contribution gets accepted into the upstream version. (Michael expresses some concern that the folks at Sun may be too caught up with their own work in this area to review Novell’s submission.)

Since that first post on this subject, several people have submitted macros for the team to test. When I started this, I wondered how long before the team would ask me to back it off a bit, but so far they tell me to keep ‘em comin’. So, if you find macros that don’t work in the Novell Edition of OpenOffice on SLED10, let me know! It’s still thaeger at my company’s name .com. (Please include “VBA Macro” somewhere in the title.)

Yesterday, Michael sent me an email with a spreadsheet attached showing the list of functions that the team are now working on integrating. It’s a solid list, and I really respect their process. Rather than run the fool’s errand of parsing the entire VBA language, the team is taking a more parsimonious route. They’re using community- and customer-submitted macros to determine which VBA features/functions we currently support inadequately (or not at all). According to their apparent frequency of usage, the team is first taking on the parts in which they can make the biggest impact (most likely weighed against development effort to complete, of course).

The best part of the file Michael sent to me was that the data was formatted into a “Data Pilot,” which is OpenOffice’s analog to the Microsoft Excel “pivot table.” Data pilots, as well as support for xls pivot tables, is a whole new feature area in that I really ought to post something about, too. (So many features, so little time.)

As an interesting side phenomenon, many Macintosh community members were recently alarmed to learn that apparently Microsoft has made some kind of announcement about Microsoft stating that they may be dropping support for VBA macros in Excel on Mac. That linked many Mac users over to my blog post, and produced a couple more macro submissions. I’ve always had a lot of respect for the Mac. It’s a great platform. (In fact, I survived my college years using an old Mac XL. That’s right, a converted Lisa!) These Mac users now see OpenOffice as a potential salvation to Microsoft’s abandoning them. Yet another reason for open source, methinks. Again, I hope that Sun are not so distracted by fixing their proprietary VBA support that they can take a look at integrating Novell’s patches up‑stream.

[22Aug06 Update: Noel Power provides some answers on macro security.]

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.