My OpenOffice macros seem to have disappeared. I last used them about 3 months ago. I have full hard drive backups going that far back in time so I can recover the macros if they were stored on my hard drives. Where can I find them or recover them? I'm using OpenOffice 3.3.0 and Windows XP.
The solution was to restore a backup version of file c:\Documents~\.......\Application~\openoffice.org\user\basic\standard\Module1.xba. Thanks toall for your help
[Solved] Lost Macros
[Solved] Lost Macros
Last edited by hwaldman2 on Sun Jul 10, 2011 7:05 pm, edited 1 time in total.
OpenOffice 3.2.1, Windows XP
- Hagar Delest
- Moderator
- Posts: 33394
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: Lost Macros
They should be in your profile: [Tutorial] The OOo user profile.
Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE Faye) and 24.8 portable on Windows 11.
Re: Lost Macros
C:\Docs&Settings\<user_name>\openoffice\3\user\Script\<language_name> contains the source code files for the respective language except for Basic where everything is more complicated than necessary.
C:\Docs&Settings\<user_name>\openoffice\3\user\basic\script.xlc registers all libraries:
First 4 lines of my script.xlc with the registration of the Standard library:
The libraries are organized in sub-directories where each directory has a registration file script.xlb where each module is registered.
Unregistered libraries or modules won't be visible in the GUI although the source code may be there.
To make things worse, the source code is XML encoded. I can load it into Firefox and copy the plain code into an editor.
C:\Docs&Settings\<user_name>\openoffice\3\user\basic\script.xlc registers all libraries:
First 4 lines of my script.xlc with the registration of the Standard library:
Code: Select all
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE library:libraries PUBLIC "-//OpenOffice.org//DTD OfficeDocument 1.0//EN" "libraries.dtd">
<library:libraries xmlns:library="http://openoffice.org/2000/library" xmlns:xlink="http://www.w3.org/1999/xlink">
<library:library library:name="Standard" xlink:href="$(USER)/basic/Standard/script.xlb/" xlink:type="simple" library:link="false"/>
Unregistered libraries or modules won't be visible in the GUI although the source code may be there.
To make things worse, the source code is XML encoded. I can load it into Firefox and copy the plain code into an editor.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: [Solved] Lost Macros
In my case the Modules were still visible in the IDE (Alt F11), but when each was clicked on they seemed to be empty.
Villroy provided the clue. Somehow the script.xlc file had become corrupt and when I restored this file from a backup everything worked again.
Thanks
Villroy provided the clue. Somehow the script.xlc file had become corrupt and when I restored this file from a backup everything worked again.
Thanks

OOo 2.3.X on MS Windows Vista