USING EXCEL ADD-INS TO SHARE VBA CODE

Part one of a four-part series of blogs

If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.

Sharing Code across Workbooks using Add-Ins (this article)
Useful Examples of Code to Share
Creating an Add-In
Using Add-In Functions

This blog is part of our Excel VBA online tutorial. Wise Owl also run excellent classroom-based VBA courses!

Posted by Andy Brown on 05 March 2012 | 2 comments

Sharing Code across Workbooks using Add-Ins

Often you'll create a bit of code so useful that you want it to be available whenever you're using Excel. By far the best way to do this is to create an add-in. This blog shows:

3 examples of code that you might want to share between workbooks;
How to create an add-in; and
How to reference an add-in that you've created in code.

Let's start with why you might want to create an add-in, by looking at 3 examples of useful functions to share.

USING EXCEL ADD-INS TO SHARE VBA CODE

Part one of a four-part series of blogs

If you've written a killer function, you'll want to be able to share it between workbooks. The best way to do this is using an add-in.

Sharing Code across Workbooks using Add-Ins (this article)
Useful Examples of Code to Share
Creating an Add-In
Using Add-In Functions

This blog is part of our Excel VBA online tutorial. Wise Owl also run excellent classroom-based VBA courses!

Comments on this blog

This blog has 2 comments:

Comment added by NARAYANK991 on 06 June 2012 at 05:46 GMT

Hi Andy ,

Thank you for a detailed and clear explanation.

Comment added by DWJ on 15 June 2012 at 21:09 GMT

This works fine when using the add-in on one computer. But I'm finding that sometimes Excel revises the add-in function name to include fully-qualified pathname of the add-in file, so then the function will fail on another computer even if it has the add-in installed. Any idea how to prevent this?

Thanks!

Reply from Andy Brown (blog author)

To be honest, no - I wasn't aware of this. Try these steps for releasing add-ins - I'd be grateful if you could comment here on your findings.

USING EXCEL ADD-INS TO SHARE VBA CODE

Part one of a four-part series of blogs

Sharing Code across Workbooks using Add-Ins

USING EXCEL ADD-INS TO SHARE VBA CODE

Part one of a four-part series of blogs

BLOGS BY TOPIC

BY AUTHOR

BY YEAR