Hi Andreas; > So we have solved this particular case of disappearing macros - somehow.
Not really. My test macros continue to live even if I open and close the Calc Linux version of MembershipTest2.xls, while the project oriented macros and macro library disappear the instant it is closed. They all disappear when I email them to myself and load them into Excel. This isn't surprising although regretful. >From everything that I have read, VBA should not come into it until the spreadsheet is loaded into Excel. Before then, all my macros and libraries should remain intact whether *.xls or *.ods until confronted by something that is M$ > Notice that almost none of your macros can run with the other > application due to the completely different APIs. The differences > between the StarBasic language and VBA (Microsoft Visual Basic for > Applications) are marginal, but the thingies you talk to are completely > different. > A Basic function like this one should work with both applications > because it does not access the API: > Function CrossFoot(Param) > Txt = cStr(Param) > For i = 1 to Len(Txt) > lResult = lResult + cInt(mid(Txt,i,1)) > next > CrossFoot = lResult > End Function > It uses the common functions and declarations of both basic dialects. Quoting from another branch of this thread (I don't know how it got broken -- but anyways ...) William Case wrote: >A thought. If I download OOo for my WindowsXp will I see much of a >difference from the Linux version and will I be able to end up with an >Excel usable spreadsheet? When I am finished will I be able to import >it back into Linux (FC5)? > > Andrew Douglas Pitonyak wrote: "They are very similar and yes, you can move the files between machines with no problems, I do it all the time." Now, I am getting gun-shy. I would like to show off a OOo Calc solution but I don't want to write another whole set of macros to loose them again. As a practical matter, knowing I am the only one using Linux and Calc how should I build my project? All WindowsXP and Excel, download OOo for WindowsXP or is there a way I can start in Linux OOo Calc and transfer the finished or partially finished product to Linux. By the way, it shouldn't make any difference if I transfer my project files by mounting my WindowsXP partition or by emailing myself, should it? -- Regards Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
