This article describes how to share Visual Basic for Applications (VBA) code between users.
There are two methods you can use to share VBA code in FrontPage. To share VBA code in FrontPage, you can import and export forms, or you can share the
Microsoft FrontPage.fpm file.
Method 1: Export and Import Userforms and Modules
To export files, follow these steps:
- In the Visual Basic Editor, select the module or form you want to export.
- On the File menu, click Export File.
- Select a hard disk location, and click Save.
To import files, follow these steps:
- In the Visual Basic Editor, click Import File on the File menu.
- Select you user form or module, and click Open.
Method 2: Share the Microsoft FrontPage.fpm File
WARNING: If you copy a
Microsoft FrontPage.fpm over an existing
Microsoft FrontPage.fpm file, anything existing in the original file will be lost, and can not be recovered. Microsoft is not responsible for code lost using this method.
The
Microsoft FrontPage.fpm file contains all the user forms, modules, code information, and VBA configuration for FrontPage.
If you want to share this file, you may access this file in the Application Data folder on your computer. Microsoft FrontPage searches for the Microsoft FrontPage.fpm file when you start the Visual Basic Editor from FrontPage.
Check the following options to share the file:
- If you want to use modules and user forms from another computer, you may rename your local file to MyCopy of Microsoft FrontPage.fpm and copy a Microsoft FrontPage.fpm file from another computer into this folder.
- If you are using Windows NT, the Microsoft FrontPage.fpm file is located at the following hard disk location:
����
C:\WINNT\Profiles\username\Application Data\Microsoft\FrontPage\Macros
��where username is the name of the user that is logged-in.
- If you are using Windows 95 or 98, the Microsoft FrontPage.fpm file is located at the following location:
����
C:\Windows\Application Data\Microsoft\FrontPage\Macros - If you are using user profiles, the file will be located at the following hard disk location:
����
C:\Windows\Profiles\username\Application Data\Microsoft\FrontPage\Macros
��where username is the name of the user that is logged-in.
Note: Be very careful when you use this method. If you accidentally copy a
Microsoft FrontPage.fpm file over an existing
Microsoft FrontPage.fpm file, anything existing in the original file will be lost and can not be recovered.