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

--
Vindalo
-----------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...fo&userid=3263
View this thread: http://www.excelforum.com/showthread.php?threadid=57413

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


--
Vindaloo
------------------------------------------------------------------------
Vindaloo's Profile: http://www.excelforum.com/member.php...o&userid=32634
View this thread: http://www.excelforum.com/showthread...hreadid=574131