ModulesAddIn_BulkImportExport |
Post Reply |
Author | |
A.D. Tejpal
Microsoft MVP Joined: 30 Jun 2008 Status: Offline Points: 192 |
Post Options
Thanks(0)
Posted: 14 Oct 2008 at 3:23am |
ModulesAddIn_BulkImportExport This utility enables bulk import of .bas, .cls or .txt files as general or class modules, or export of existing modules to destination folder as .bas / .cls files. Requirements References: Note: It is not necessary for the host db to have the above references. Installation: Open any database in Access and click on Tools > Add-Ins > Add-In Manager. Use: Imp: Before invoking the AddIn, it should be ensured that the host db is free of any compile error. Technical Notes: Add-In named ModulesAddIn_BulkImportExport, when invoked in the host db, displays a list box at right showing existing modules. On clicking the command button captioned "Get Folder", the user can browse to the folder containing .bas, .cls or .txt files required to be imported as modules. As soon as the folder is selected, the list box at left displays the names of files contained in this folder, along with type of module and line count. Selection of one or more files in the list box, followed by clicking of button captioned "Import", imports the selected files as new modules. Sorting is devised in such a manner that freshly imported modules get displayed prior to those already existing.
Similarly existing modules as selected in the list box at right, can be exported as .bas / .cls files to destination folder. This folder, named ExportedModules, gets created in the same directory where the host db is located. Certain interesting factors pertaining to Add-Ins in general, are mentioned below: 1 - For code contained in modules belonging to the Add-In: Download File >>: uploads/37/ModulesAddIn_BulkImportExport.zip
|
|
Sponsored Links | Want a good read? Try The Summer of His Life (available on Amazon!) |
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |