[Solved] Lost Macros

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
hwaldman2
Posts: 3
Joined: Sat Jul 17, 2010 4:37 pm

[Solved] Lost Macros

Post by hwaldman2 »

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
Last edited by hwaldman2 on Sun Jul 10, 2011 7:05 pm, edited 1 time in total.
OpenOffice 3.2.1, Windows XP
User avatar
Hagar Delest
Moderator
Posts: 33394
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Lost Macros

Post by Hagar Delest »

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.
LibreOffice 25.2 on Linux Mint Debian Edition (LMDE Faye) and 24.8 portable on Windows 11.
User avatar
Villeroy
Volunteer
Posts: 31345
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Lost Macros

Post by Villeroy »

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:

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"/>
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.
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
User avatar
voobase
Volunteer
Posts: 97
Joined: Tue Jan 15, 2008 3:07 pm
Location: Australia

Re: [Solved] Lost Macros

Post by voobase »

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 :)
OOo 2.3.X on MS Windows Vista
Post Reply