Importing VBA code
I have a VBA project that I am doing in excel. I will have many books using the same code, and I don't want to copy the code across all the books if I make changes. Is there anyway code in one central place and then all books have access to that code?
Yes, you have two options
1) Copy and paste the code into your personal ledger.
More details here
Topic: Deploying Excel Macros from a Central File
Link : http://office.microsoft.com/en-us/excel-help/deploy-your-excel-macros-from-a-central-file-HA001087296.aspx
2) Create add-on
Mode details here
Topic: Creating an XLA Add-in for Excel
Link : http://www.cpearson.com/excel/createaddin.aspx
Note. You can create add-in in VBA as well as Visual Studio. For COM add-ins (created with Visual Studio) refer to this link.
Topic: Office Development with Visual Studio (VSTO)
Link : http://msdn.microsoft.com/en-us/office/hh133430
NTN
Sid