| View previous topic :: View next topic |
| Author |
Message |
Sergej General User

Joined: 07 Dec 2006 Posts: 7
|
Posted: Tue Jan 23, 2007 7:26 am Post subject: Macro attached to the database |
|
|
Hello everybody!
When I copy my database from one computer to another, the macros don't copy.
I mean, they are not attached to the database file itself.
Can you please help me how to make the database(all forms, queries and the data itself) ONE with the macros, so that I can distribute everything in one file to my partners.
Thank you! |
|
| Back to top |
|
 |
noranthon Super User

Joined: 07 Jul 2005 Posts: 3318
|
Posted: Thu Jan 25, 2007 5:44 pm Post subject: |
|
|
IIRC, a database cannot have a macro library, so your macros are probably in macro libraries, listed under "My Macros" in the macros organiser.
I think you will have to copy the files containing your macros as well as the database itself. You will find them in the "Basic" folder of your user settings folder. Copying the whole Basic folder would make all macros in "My Macros" standard.
There is a post on distributing macros in the Help sticky in Macros & API. If you want your thread transferred there, send a pm to me or one of the other moderators. _________________ search forum by month |
|
| Back to top |
|
 |
audionuma OOo Enthusiast


Joined: 23 Feb 2006 Posts: 126 Location: France
|
Posted: Fri Jan 26, 2007 2:41 am Post subject: |
|
|
hello,
you cannot save macros in the .odb document, but you can save them in an embedded form, which will follow with the .odb file.
Manuel _________________ OOo 2.3 / Mac OS PPC X.4.11 |
|
| Back to top |
|
 |
trenkler Power User

Joined: 21 May 2005 Posts: 55
|
Posted: Sat Jan 27, 2007 11:16 am Post subject: Re: Macro attached to the database |
|
|
| Sergej wrote: | Hello everybody!
When I copy my database from one computer to another, the macros don't copy.
I mean, they are not attached to the database file itself.
|
You can create library in MyMacros for your database where you write and use all your macros. It is easy to export the whole library as one .oxt file. Then you can append it to your libraries on another computer. I use library "lefa" for my lefa.odb database. And for each database I have it s own library.
juraj |
|
| Back to top |
|
 |
|