Planning on copying Excel Macros from one PC to another; he uses a base Macro
template for the majority of the macro's. Are there file extensions for
Macro files? I realize that the macros are associated with the specific file
or workbook, but can we locate the macros separately?

Copying all the current Excel documents to the new system should accomplish
maintaining his Macro files, am I right?