Common Code between workbooks

[Eric Griffiths]

I have created a workbook (Excel 2010) for tracking capital expenses in a project. This workbook contains about 2K lines of code for importing and exporting data between corporate subsystems.
The rest of the project managers would like to use a copy of the workbook for their projects, and I would like to know if there is a way to have the code in a common area so that I only have to maintain one copy with code changes and have them pushed to (or pulled from) the copies.
As this was originally planned to be for me, I don't want to create a maintenance nightmare

[davegugg]

You can run code from a separate workbook with

Please Login or Register  to view this content.

The workbook must be open, and you'll want to be sure to open it read-only.