TerryJ wrote:
Mark Knecht wrote:
Hi Terry,
<snip>
1) I have an OO spreadsheet on one machine. It's called ibd100.ods.
When I use this spreadsheet on this specific machine the macros work.
2) When I look at Tools->Macros->Organize Macros->OpenOffice.org Basic
I see the macro existing under "My Macros->Standard->Module 1" named
cptoa1.
So the macros are stored on the computer in the user area and are not in
the document.
also, the macros are in the Standard library so you can NOT import them
to another document because you can not import the standard library.
Very sad indeed.
3) When I transfer this spreadsheet to another machine the macros don't
work.
Because the macros are not stored in the document.
4) On the new machine hen I look at "My Macros->Standard->Module 1"
the cptoa1 macro doesn't exist explaining why it doesn't work.
OK - how to get the macro out of the first machine and over to the
second machine?
Earlier Anthony suggested (I think) to export the macro. However when
I use the 'Organizer' button I cannot find an export function to
export the macro to a file. The help file doesn't talk about exporting
macros as far as I can tell so far.
Worst case, open each module in an editor, copy the entire module to the
clipboard, and then paste them into a new module. IF the module is in a
document, then it is probably much easier. Also, if you do NOT use the
Standard library, that is better because then you can import it to a new
library container directly.
I create my own libraries and then I copy the entire directory. I then
"import" that library in the copied directory.
Does any particular method sound like you would like more information?
Maybe the mistake is having the macro in the My Macros group? Should
it be in the spreadsheet name group?
Anyway, I still cannot get the macros over to the second machine so
I'm really in need of some help.
Thanks,
Mark
On 6/21/07, TerryJ <[EMAIL PROTECTED]> wrote:
Are you using the .ods format? Macros would not, I think, be converted
to
the .xls format.
Mark Knecht wrote:
<snip>
First, to save a macro in a document (so that it is part of the document,
not in a "My Macros" library), open the editor (more in a moment). The
tool-bar should include a box containing a list of libraries. Your document
will be at the bottom of the list. The first time you open it, there will
be a blank window saying "<No Module>".
Near the bottom of the window is a horizontal scroll bar. Right-click the
panel to the left of that. Select Insert >BASIC module. Paste or write
your macro code in the module.
To get the Editor, Tools >Macros >Organise Macros >OpenOffice.org Basic. On
the "Organise" dialogue, press the "Edit" button. There is a shortcut.
Tools >Customise : Choose your tab : Function "Application" : Category "Edit
Macros".
Secondly, you can export any module to a text file using the icon towards
the right end of the lower tool-bar in the Editor. The tool tip is "Save
Basic". The file will have the extension .bas. You can import any such
file into your module using the icon to the left, tool tip "Insert BASIC
source".
Finally, you can import macros using the Organiser. On the Organise
dialogue mentioned earlier, press the button labelled "Organiser". There is
an icon on or available for the Editor tool-bar with the tool tip "Select
Macro" which calls the dialogue and it can also be called from the Editor
menu Tools >Macros >Organise etc.
On the third tab ("Libraries"), select the location to which you wish to
import the macros. It lists the shared libraries, My Macros and open
documents. The "append" button is only enabled for the last two. That
button gets you a file browser-selector. Once you've chosen the source of
your macros, you get another dialogue. Mind how you go.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
My Book: http://www.hentzenwerke.com/catalog/oome.htm
Info: http://www.pitonyak.org/oo.php
See Also: http://documentation.openoffice.org/HOW_TO/index.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
