Book review - Learn OpenOffice.org Spreadsheet Macros

If you love using macros in spreadsheets, OpenOffice macros might suit all your needs

By Phil Shapiro, PC World |  Software, OpenOffice.org

In our audio interview you asked whether a macro application created in Calc could run in Excel. The answer is a qualified yes. The code would have to be created in Calc using Excel's Visual Basic for Applications (VBA) language, not Calc's native OpenOffice Basic. That can be done -- Calc can handle VBA. One only need to place as the first line of code in a module the header "Option VBASupport 1." However, when you import into Excel, all of Calc's macro code is stripped out (at least in Excel 2007 it is). So one would need to import the Calc spreadsheet into Excel, and then copy and paste the VBA code into an Excel module. Macros that are coded in OpenOffice Basic Code (instead of VBA) will not function in Excel.

An interesting capability of Calc is that within a given spreadsheet file there can be a mix of OpenOffice Basic and Visual Basic code -- and the application will run just fine. So if you have already coded an application in OpenOffice Basic and a collaborator has worked on other pieces in VBA, the VBA code can be imported into the Calc file (there may need to be some tweaking, depending upon the complexity of the code). Now that's user friendly!

Phil Shapiro

The blogger is an educator and community builder in the Washington DC-area. He can be reached at philshapiroblogger@gmail.com and on Twitter at http://www.twitter.com/philshapiro

Previous blog posts:

Honoring Paul MacReady with New Bicycle-Powered Inventions

Cell Phone Rebates an Ongoing Problem

Talking Back to the New York Times

Why I'd Choose St. Louis for Google's Gigabit Fiber Project

Public Libraries as Business Incubators

It's Time for Public Libraries to Get Creative

A Profile of Brennon T. Williams, Techie Entrepreneur

A Review of Verizon's One-on-One Droid Training

Tetravex Logic Puzzles on Martin Luther King Day


Originally published on PC World |  Click here to read the original story.
Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Answers - Powered by ITworld

ITworld Answers helps you solve problems and share expertise. Ask a question or take a crack at answering the new questions below.

Join us:
Facebook

Twitter

Pinterest

Tumblr

LinkedIn

Google+

Ask a Question
randomness