Multi-Code Import/Export Add-In

The Multi-Code Import/Export tools provide a simple way to share many Microsoft® Visual Basic® for Applications (VBA) objects with other developers. Using these add-ins, you can save time and minimize cut-and-paste errors by transferring multiple code modules in and out of a project in a single operation.

To open the Multi-Code Import/Export add-ins, open the Visual Basic Editor (ALT + F11) from the Microsoft® Office application in which you created the component. If the Multi-Code Import/Export tools are not listed in the Add-Ins menu, you must first load it, using the Add-In Manager located in the Add-Ins menu. When the tools are loaded, you can launch them from the Add-Ins menu. To load the Multi-Code Import/Export add-ins into the Add-In Manager, select the add-ins, and select the Loaded/Unloaded check box.

In This Section

• Multi-Code Import Window
  Using the Multi-Code Import tool, you can easily import portions of your code to the current project.
• Multi-Code Export Window
  Using the Multi-Code Export tool, you can easily export portions of your code.
• Select Files to Import Dialog Box (VBA Multi-Code Import/Export)
  Use this dialog box to search for and select Microsoft® Visual Basic® for Applications (VBA) code modules to import into your current VBA project.
• Browse for Folder Dialog Box (VBA Multi-Code Import/Export)
  Use this dialog box to identify a target folder to receive the exported Microsoft® Visual Basic® for Applications (VBA) code modules.
• Multi-Code Export Results Dialog Box (VBA Multi-Code Import/Export)
  This window displays the results of the export, indicating each file listed in the Selected Objects list of the Multi-Code Export window and whether or not the export was successful.

Related Sections

• Office Developer Productivity Tools
  A number of tools designed to aid in rapid application development in the Microsoft® Visual Basic® Editor are provided with Microsoft® Office XP Developer.
• Office Developer Productivity Tools Add-In Manager
  With the Add-In Manager, you can load any or all of the Microsoft® Office Developer productivity tools that you require, and have them appear in the Add-Ins menu.
• Code Commenter and Error-Handler Add-In
  Automatically insert error handling and code comments into your code based on a template.
• VBA Source Control Add-In
  The VBA Source Control add-in provides check in/check out, versioning, history, and other important source code management functions for use in the Microsoft® Visual Basic® for Applications (VBA) environment.
• VBA String Editor
  Create strings quickly and easily, and in the proper syntax using the String Editor.