Language Selection

English French German Italian Portuguese Spanish

OpenOffice.org Calc adds support for Excel VBA

Filed under
OOo

As an Excel user, you may have looked at OpenOffice.org and found that it doesn't support Visual Basic for Applications (VBA), the Microsoft Office macro language. If you've spent years building hundreds of Excel macros, the fear of losing them all could keep you locked in to Office. If so, it's time to look again; Novell has taken OpenOffice.org's source code and create a version of its own that supports Excel VBA.

Novell's Noel Power is the developer in charge of introducing Excel VBA interoperability into OpenOffice.org Calc. He says that the interoperability is achieved by:

* allowing Excel VBA macros to run natively within OpenOffice.org;
* providing a compatibility object model;
* continuously improving the compatibility model by identifying and implementing the most useful and widely used APIs;
* extending the symbols available to ooo-basic to include the compatibility API; and
* modifying the core ooo-basic runtime to handle Excel VBA syntax.

Noel says, "Novell is pushing this to the wider community. The source code is freely available from the OpenOffice.org Hackers Pages, and instructions on how to build it are on the OpenOffice.org build page. Additionally, we are pleased to say that we are also shipping the VBA interoperability feature with Novell's branded OpenOffice.org versions for Windows.

Full Story.

More in Tux Machines

today's howtos

Leftovers: Gaming

Make Your Mark on the World With Linux

Linux and FOSS have already changed the world, and we're just at the beginning. This is a great time to learn to be a maker, in contrast to being a mere consumer. Clicking buttons on a smartphone is not being tech-savvy; hacking and building the phone is. Some people give Make Magazine the credit for launching the Maker Movement. Whether they launched it or just gave it a name, it is a real phenomenon, a natural evolution of do-it-yourselfers, inventors, and hackers in every generation. Remember Popular Mechanics, Popular Science, Hands-On (for Shopsmith projects), photography magazines, woodworking magazines, electronics...remember Heathkit? Remember when Radio Shack was still an electronics store? How about Edmund Scientific? That is still a wonderful playground of anatomical models, microscopes, telescopes, dinosaurs, prisms, lenses, chemistry sets, lasers, geology stuff, and tons more. All of these still exist, and have moved online like everything else. It's a feast of riches, plus we have all the cool new stuff that Make Magazine covers. This is absolutely the best time to be a curious tech adventurer. Read more

XnConvert Review – An Image Batch Processor like No Other

XnConvert is batch image processor that has been designed to work on multiple operating systems. It comes with a Linux client and it's one of the few tools of its kind on this platform. Let us now take a closer look at the application to see why it's incredibly useful. Read more