Visual Basic Extensibility Reference
Export Method (VBA Add-In Object Model)
Saves a component as a separate file or files.
The Export syntax has these parts:
|object||Required. An object expression that evaluates to an object in the Applies To list.|
|filename||Required. A String specifying the name of the file that you want to export the component to.|
When you use the Export method to save a component as a separate file or files, use a file name that doesn't already exist; otherwise, an error occurs.