[SOLVED] where are macros stored in libre office calc 3.6.2+

knobby67 · 04-24-2013, 10:03 AM

hi All,
I had a harddrive failure, so installed the latest ubuntu 12.10. By default this has updated libre office. I went to copy my macros from the hidden libreoffice folder on my old harddrive ( under user .libreoffice basic ) and copy them across to the same folder ( as I have done in the past ) however the new office doesn't appear to use .libreoffice folder in user. I also can't search as the search tool appears to have vanished ( FROM UBUNTU 12.10) and using dash to serach just links me to office books to buy from Amazon ( ahh! ).
Can anyone advise where libre office now puts it's basic folder for macros?
Thanks in advance

jdkaye · 04-24-2013, 10:36 AM

Salve,
I'm now using LibreOffice v.4 and the macros appear to be stored here:

Code:

~/.config/libreoffice/4/user/basic/Standard/Module1.xba

In version 3 they were stored here:

Code:

~/.libreoffice/3/user/basic/Standard/Module1.xba

ciao,
jdk

knobby67 · 04-25-2013, 11:23 AM

Thanks .config is where it's at for 3.5.2 office.

Sorry admin I don't know how to click solved, can see a button anywhere

jdkaye · 04-25-2013, 11:28 PM

Quote:

Originally Posted by knobby67

Thanks .config is where it's at for 3.5.2 office.

Sorry admin I don't know how to click solved, can see a button anywhere

use the Thread Tools menu located just above your first post on this thread.
Thanks,
jdk