How to Copy Excel Macros From One PC to Another

1. Open the Visual Basic Editor (VBE) on the computer you want to transfer the file from by clicking on 'Alt' and 'F11' on your keyboard.
2. Right click on the module you want to export. The module list is on the left hand side of the VBE window.
3. Click on 'Export File.'
4. Select a save location on a thumb drive.
5. Move the thumb drive to the other PC.
6. Open the VBE on the PC you want to copy the file to.
7. Click on 'File' and then click on 'Import File.'
8. Click on the file location in the thumb drive, then click on 'Open.'