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?

+3

DasPete 03 Apr 12 at 21:14

source to share

1 answer

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

+2

Siddharth Rout 03 Apr 12 at 21:23

source to share

All Articles