Running a VBA in all excel files

[Rick Rothstein]

The following VB code (amount to words conversion) was given by Rick very long back. Its been really helpful to me. However, it only works on one excel. If at all i need to make it work on a new excel file, i need to paste the code and do all the procedures all over again to get the formula running.

Could someone show a shortcut or anything on how i can save this formula, so that whenever i open a new excel file, the formula is already available. As i am a newbie to Excel i would require detailed explanation.

Start a new workbook, copy/paste the code into it, then save the workbook using "Excel Macro-Enabled template" as the "Save as type" (use the directory that Excel defaults to, but give the workbook a name you will recognize as having this code in it). That's it... the next time you start a new Excel file that needs this functionality, click New, in the template list that appears, click on "My templates..." and choose the file with the name you just save the above under.