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!
Previous blog posts: