| So far, you've seen that modules are where most of the VBA action takes place. True, as you'll see in subsequent chapters, you'll also be working in user form windows and the Properties window, but modules are really the heart of VBA. Given that, it will help to have a few module manipulation techniques under your belt. To that end, the next four sections show you how to rename, export, import, and remove modules. Renaming a Module When you insert a new module, VBA gives it an uninspiring name such as Module1. That's fine if you'll just be using the one module in your project, but if you'll be working with multiple modules, you should consider giving meaningful names to each module to help differentiate them. To rename a module, follow these steps: -
Select the module in the Project Explorer. -
In the Properties window, use the ( Name ) property to rename the module. Make sure the name you use begins with a letter, contains no spaces or punctuation marks (underscores are acceptable, however), and is no longer than 31 characters . Exporting a Module The procedures and functions in a module will usually be specific to the application in which the project was created. For example, procedures in a Word-based module will usually reference Word-specific objects such as bookmarks and paragraphs. However, you might have generic procedures and functions that can be used in different contexts. How, then, can you share code between applications? One way to do it is to use the Clipboard to copy data from one module and paste it into a module in a different application. Another way is to export the module to a .BAS file. In the next section, I'll show you how to import .BAS files into your VBA projects. The .BAS (Basic) file format is the one used by Visual Basic modules (which means you could use your VBA code in a Visual Basic project), but it's really just a simple text file. Here are the steps to follow to export a module: -
In the Project Explorer, highlight the module you want to export. -
Select File, Export File or press Ctrl+E. VBA displays the Export File dialog box. -
Select a location and name for the .BAS file. -
Click Save. VBA creates the new .BAS file. Importing a Module If you exported a module to a .BAS file, you can import that file as a module in another application's VBA project. Also, if you've used Visual Basic before, you can leverage your existing code by importing Visual Basic modules into your project. Here are the steps to follow: -
If you have multiple projects open , use the Project Explorer to highlight any object in the project you want to use to store the imported file. -
Select File, Import File or press Ctrl+M, to display the Import File dialog box. -
Highlight the .BAS file that you want to import. -
Click Open. VBA adds a new module for the .BAS file. Removing a Module If you no longer need a module, you should remove it from your project to reduce the clutter in the Project Explorer. Use the following technique: -
Highlight the module in the Project Explorer. -
Select File, Remove Module, where Module is the name of the module. -
The Visual Basic Editor asks if you want to export the module before removing it: -
If you want to export the module first, click Yes and use the Export File dialog box to export the module to a .BAS file. -
Otherwise, click No to remove the module. |
