Reading Functions from Common Place

Hi All

I have a question with regards to usage of "COMMON Functions / Sub Routines"
from VBScript of excel file
We have bunch of COMMON routines which we would like to Save in single
Module File and refer this module across each of XLS files within that folder

Is that possible. If so, can somebody please tell me how it is done.

Thanks
PP

In the new version of Visual Studio there are tools for office application development.
You can put your COMMON routines in there ( in vb.net or C#.net) create a .dll file
and put a reference to that file in each workbook.
When you add routines to the .dll everybody is automatically updated.

If you have more questions about this let me know.