Can't load module; invalid format

A module must be in text format. This error has the following cause and solution:

  • You attempted to load a binary format file as a module. Some versions of Visual Basic permit you to save code in both binary and text formats. If possible, reload the file in the application in which it was last saved and save it as text.

For additional information, select the item in question and press F1(in Windows) or HELP (on the Macintosh).

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.