Excel97: Moving modules from workbook to another

[Lehtoant]

Hi,<br>
<br>
I've encountered a problem with Excel97 VBE:<br>
<br>
I have a Excel5 workbook which contains sheets and one module with five macros. One of the macros should create a new copy of the workbook with slight modifications. In Excel5 VBA new workbook is easily created by selecting and copying all sheets and modules to new workbook. In 97 modules are 'hidden' and you can't treat them like sheets (select&copy) . <br>
<br>
How do I copy my macros or the whole module to new book? One workaround is to make the copy by saving the original with different name. There's also possibility to import/export code. Any tips?<br>
<br>
TIA,<br>
Al