+ Reply to Thread
Results 1 to 2 of 2

Shared VBA code between workbooks

  1. #1
    Registered User
    Join Date
    03-20-2006
    Location
    SE England
    Posts
    20

    Shared VBA code between workbooks

    Hi,

    I have a number of workbooks that are used as timesheets. Each employee has their own workbook, which contains a separate sheet for each week's data. The workbooks are all stored in the same LAN 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 code and allowing the individual workbooks to access it?

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

    Thanks,
    Vindaloo

  2. #2
    Registered User
    Join Date
    03-20-2006
    Location
    SE England
    Posts
    20
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1