Hi; I am trying to build a Linux Calc project importable into Excel, but it's not working out -- I keep losing my macros. The advice I have received range from "It can't be done" to "I do it all the time". Both statements have caveats.
>From what I have read, it seems *fairly* straight forward to import an Excel file into Windows version of Calc. It seems like I should be able to import Excel into a Linux version of Calc. But I am intirely confused about importing a Linux and/or Windows version of Calc into Excel My question is this: Are my Calc Load/Save options set correctly? I thought the Load and Save was for imported Excel documents not exported Calc documents, however, The settings are: .... Microsoft Excel 97/2000 X Load Basic code to edit X Save original Basic code again .... X = checkmark The Calc Help is ambiguous on several matters. __________________________________ Quoted from OOo Help "Microsoft Excel 97/2000 Specifies the settings for documents in Microsoft Excel 97/2000. Load Basic code to edit Loads and saves the Basic code from a Microsoft document as a special OpenOffice.org Basic module with the document." *[In this case, are 'Basic code from a Microsoft document' OOo codewords for VBA? In these circumstances, does 'Microsoft Excel 97/2000' include OfficeXP Excel 2003?] "The disabled Microsoft Basic code is visible in the OpenOffice.org Basic IDE between Sub and End Sub. You can edit the code. When saving the document in OpenOffice.org format, the Basic code is saved as well. When saving in another format, the Basic code from the OpenOffice.org Basic IDE is not saved. " *[Does 'another format' mean .xls?] "Save original Basic code again Specifies that the original Microsoft Basic code contained in the document is held in a special internal memory for as long as the document remains loaded in OpenOffice.org. When saving the document in Microsoft format the Microsoft Basic is saved again with it in an unchanged form." *[I see. The restriction is that the document has to start with VBA macros and if saved, reverts to the original macros, throwing out any editing. However, why then aren't the test macros in My Macros libraries also thrown out. They were also created in the same .xls document.] "When saving in another format than Microsoft Format, the Microsoft Basic Code is not saved. For example, if the document contains Microsoft Basic Code and you save it in OpenOffice.org format, you will be warned that the Microsoft Basic Code will not be saved. The Save original Basic code again checkbox takes precedence over the Load Basic code to edit check box. If both boxes are marked and you edit the disabled Basic Code in the OpenOffice.org Basic IDE, the original Microsoft Basic code will be saved when saving in the Microsoft format. A message appears to inform you of this." *[Sounds like I should uncheck 'Save original Basic code' and experiment again to see if that works.] "To remove any possible Microsoft Basic macro viruses from the Microsoft document, unmark the Save Original Basic Code again check box and save the document in Microsoft format. The document will be saved without the Microsoft Basic code." _________________________________________ On Fri, 2006-18-08 at 11:21 -0400, G. Roderick Singleton wrote: [to me privately] "I suspect that some combination of these is what Andrew [Pitonyak] uses. Beyond this guess I do not know. I will have a look though at the example. Remember OOo is not a clone so stuff like macro export is probably very iffy as you are finding out. Ask on the list about those settings, as this may give you a clue about what the others are saying." _______________________________________ On Fri, 2006-08-18 at 10:56 -0400, William Case wrote: "Perhaps M$ has won. I'll have to do the whole thing in Excel. If pride rears its ugly head, I'll try importing back into Linux Calc. It's cheating, but ... What the Hell? " -- Regards Bill --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
