Organising Libraries and Modules

Basic Libraries Containers

Office Basic libraries can be stored in 3 different containers:

• Application Macros: libraries stored in this container are available for all users of the computer and are managed by the computer administrator. The container is located in the Office installation directory.
• My Macros: libraries stored in this container are available to all documents of your user. The container is located in the user profile area and is not accessible by another user.
• Document: libraries stored in the document container are only available for the document and are accessible only when the document is open. You cannot access macros of a document from another document.

To access macros stored in libraries of Application Macros or My Macros from another container, including the document container, use the GlobalScope specifier.

Organising Libraries

Creating a New Library

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the Libraries tab.

3. Select to where you want to attach the library in the Location list. If you select Application Macros & Dialogs, the library will belong to the Office application and will be available for all documents. If you select a document the library will be attached to this document and only available from there.

4. Click New and insert a name to create a new library.

Import a Library

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the Libraries tab.

3. Select to where you want to import the library in the Location list. If you select Application Macros & Dialogs, the library will belong to the Office application and will be available for all documents. If you select a document the library will be imported to this document and only available from there.

4. Click Import... and select an external library to import.

5. Select all libraries to be imported in the Import Libraries dialogue box. The dialogue box displays all libraries that are contained in the selected file.

6. If you want to insert the library as a reference only mark the Insert as reference (read-only) check box. Read-only libraries are fully functional but cannot be modified in the Basic IDE.

7. Mark the Replace existing libraries check box if you want existing libraries of the same name to be overwritten.

8. Click OK to import the library.

Export a Library

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the Libraries tab.

3. In the Location list you specify where your library is stored. Select the library that you want to export. Note that you cannot export the Standard library.

4. Click Export...

5. Choose whether you want to export the library as an extension or as a BASIC library.

6. Click OK.

7. Select where you want your library exported.

8. Click Save to export the library.

Deleting a Library

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the Libraries tab.

3. Select the library to be deleted from the list.

4. Click Delete.

• Deleting a library permanently deletes all existing modules and corresponding procedures and functions.
• You cannot delete the default library named "Standard".
• If you delete a library that was inserted as reference only the reference is deleted but not the library itself.

Organising Modules and Dialogs

Creating a New Module or Dialog

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the Modules tab or the Dialogs tab.

3. Select the library into which the module will be inserted and click New.

4. Enter a name for the module or the dialog and click OK.

Renaming a Module or Dialog

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the module to be renamed twice, pausing between the clicks. Enter the new name.

In the Basic IDE, right-click the name of the module or dialog in the tabs at the bottom of the screen, choose Rename and type in the new name.

3. Press Enter to confirm your changes.

Deleting a Module or Dialog

1. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

2. Click the Modules tab or the Dialogs tab.

3. Select the module or dialog to be deleted from the list. Double-click an entry to reveal sub-entries, if required.

4. Click Delete.

Deleting a module permanently deletes all existing procedures and functions in that module.

Organising Projects among Documents or Templates

Moving or copying modules between documents, templates and the application.

1. Open all documents or templates among which you want to move or copy the modules or dialogs.

2. Choose Tools - Macros - Organise Macros - Office Basic and click Organiser or click the Select Module icon in the Basic IDE to open the Macro Organiser dialogue box.

3. To move a module or dialog to another document, click the corresponding object in the list and drag it to the desired position. A horizontal line indicates the target position of the current object while dragging. Hold the Ctrl key while dragging to copy the object instead of moving it.