Import a Text File into Code
This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.
You can import a text file containing code into the current module and use it in your code.
To import a text file into a module
Open the module into which you want to insert text and position the entry point at the place where you want the text inserted.
On the Insert menu, click File.
The Insert File dialog box appears.
Use the Insert File dialog box to select the file to import.
Click OK.