Shared VBA code between workbooks

[Vindaloo]

Hi,

I have a number of workbooks that are used as timesheets. Eac
employee has their own workbook, which contains a separate sheet fo
each week's data. The workbooks are all stored in the same LA
directory.

I have several functions / subs in each workbook that are identical
what would be the best way of maintaining only one version of this cod
and allowing the individual workbooks to access it?

I would guess at creating an add-in and storing it on the LAN - is thi
the best way?

Thanks,
Vindalo

 

[Vindaloo]

Since creating this thread I've done the following:

Removed the module from the original workbook and saved it as an XLA.
Loaded this XLA using Tools --> Add-ins
Added a reference to the XLA Project so that the original workbook can
use the subs / functions in the XLA.

Does this sound about right before I modify everyone's timesheet to use
the new add-in?

Thanks,
Vindaloo