1. Please press "ALT+F11" key combination. Microsoft Visual Basic for Applications window will appear.
2. Select from "File" menu - "Import File... (CTRL+M)".
3. Select TestModule.bas from your hard drive and press "Open" button. New "Module1" will be shown in VBAProject window
4. To View Macros code right click and select "View Code". "TestModule" VBA macros code will be shown
5. Please return to Sheet1 window, press "ALT+F8", select "TestModule" in "Macro" window and press "Run" button.
Your VBA macros in .bas format will be executed. These are results of TestModule.bas macros running. You can download Book1 XLS file with TestModule.
Video guide: