AddFromFile method (VBA Add-In Object Model)
For the References collection, adds a reference to a project from a file. For the CodeModule object, adds the contents of a file to a module.
Syntax
object.AddFromFile (filename)
The AddFromFile syntax has these parts:
| Part | Description |
|---|---|
| object | Required. An object expression that evaluates to an object in the Applies To list. |
| filename | Required. A string expression specifying the name of the file that you want to add to the project or module. If the file name isn't found and a path name isn't specified, the directories searched by the Windows OpenFile function are searched. |
Remarks
For the CodeModule object, the AddFromFile method inserts the contents of the file starting on the line preceding the first procedure in the code module.
If the module doesn't contain procedures, AddFromFile places the contents of the file at the end of the module.
See also
- Collections (Visual Basic Add-In Model)
- Visual Basic Add-in Model reference
- Visual Basic language reference
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.