AddFromFile Method (VBA Add-In Object Model)

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

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.



The AddFromFile syntax has these parts:




Required. An object expression that evaluates to an object in the Applies To list.


Required. A string expression specifying the name of the file 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.


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.