Hi! I am probably doing things the very wrong way again, as usual.
I have a spreadsheet on which I put three buttons to call thrre different macros, which runs a couple of subroutines and functions. I want to write each macro in different modules and I want them all to follow the document, since I intend to run them on at least two different computers (which both have OpenOffice.org 2.1 installed, of course). Now, when I tried to do this I found that two of the three macros had a lot in common, such as a few functions. An idea is to write those functions in a separate module or in the same module as one of the two similar macros. However it doesn't seem to be possible to call a function or subroutine from one Basic-module to another. I tried a few of the ideas that came up in my head, but none of them worked. I also tried to find something about it in Andrew Pitonyac's macro manual, but if it's there I obviously missed it. I know that I can copy them to My Macros, but I want all functions to follow the document, at least for the moment, until I made everything to work properly. To try to explain better, I have my subroutines and functions organized like this (I changed the names of most things in this example): MyMacroDocument.ods -> Standard -> CellFunctions: I wrote a few cell functions, but don't bother about them, because they are not a part of my problem... MyMacroDocument.ods -> Standard -> OneMacro: A macro with a few subroutines and functions. MyMacroDocument.ods -> Standard -> AnotherMacro: A macro with a few subroutines and functions, some of them are exactly the same as some of the OneMacro ones, so I thought that I wouldn't have to write them (or copy-paste them) again. Do anyone have a clue about what I am talking about and how to solve the "problem"? Thanks Johnny
