[Solved] Transfer Macro Dialog to a different PC

[Shreve Johnson]

Novice user here and just created my first Macros and Dialog in OpenOffice Calc which need to be transferred to another PC. I have saved macros as a .txt file which I can transfer to another PC but I do not know how to transfer DIalog to this other PC.

Any help will be appreciated. Thank you.

[Charlie Young]

The toolbar in the Dialog Editor has "Import Dialog" and "Export Dialog" buttons. The Export button saves the dialog to an XML file with the extension .xdl, and the import button imports such files. You can also copy your .ods file, rename it to .zip, and extract its files. The dialogs will be in the extracted Dialogs folder as .xml files under "Standard" or whatever library name you may have created. These .xml files are identical to the .xdl files created by Export.

[Hagar Delest]

You can also embed your macros + dialogs in an extension. There is the Basic extension builder (or something like that) that is an easy wizard to do such operation. Then it's very easy to install the macro on other machines.

Please add [Solved] at the beginning of the title in your first post (top of the topic) with the edit button if your issue has been fixed.

[Shreve Johnson]

I checked out the export and import buttons on the toolbar and exported the xdl file for the Dialog. I am now waiting for the other PC to do the import when the PC is available. Will post later when all done. Thanks all.

[Villeroy]

Easiest method:

if all your code and dialogs are in the "Standard" library:
Call the macro organizer, tab "Libraries"
Create a new library (not the "Standard" one).
Move the modules and the dialogs into that library.
Adjust the script events to the new location.
endif

Create an extension from that library.

A double-click installs that extension on the target system.

Next time you start your macro project with a separate, uniquely named library.

[Shreve Johnson]

Hi,
I tried to import dialogs on the other PC using Charlies method above but could not find the import button. I could only see the export button. This other PC has Windows 7 and OpenOffice 3.4.1. I can see the import button on my PC which has windows vista and OpenOffice 3.4.1. Not sure how to locate the import button or do the import to this other PC. Hoping somebody can help

I was in a rush and tried to use Villeroys method but got lost on line 4 "Move the modules and ....".

THANKS.

[Villeroy]

Tools>Extensions... installs all kinds of extensions (templates, dictionaries, macros and UNO components).
The import button for exported libraries (folders with code and dialogs not bundled in extensions) sits right above the export button on the library tab of the macro dialog.

[Shreve Johnson]

I installed OpenOffice 4 on the other PC. The import button was now visible and I was able to import the Dialogs on this other PC. Going is slow at my end but problem solved. Thank you all.