[Solved] Lost Macros

[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

[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.

[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.

[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