View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Vindaloo[_7_] Vindaloo[_7_] is offline
external usenet poster
 
Posts: 1
Default Shared VBA code between workbooks


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