Import a Text File into Code

Office 2013 and later

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

  1. Open the module into which you want to insert text and position the entry point at the place where you want the text inserted.

  2. On the Insert menu, click File.

  3. The Insert File dialog box appears.

  4. Use the Insert File dialog box to select the file to import.

  5. Click OK.