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.

This blog is part of our Excel VBA training blog.

Learn how to write VBA macros to add, edit and delete data in Access, SQL Server and other databases, using something called ADO.

This blog is part of both a complete Excel VBA tutorial and a complete SQL tutorial.

Did you know that you can create and manage references from within VBA code? This article gives you ideas on how to do just that.

This blog is part of a complete online VBA tutorial.

Although it's usually easiest to create references to other applications using Tools -> References as described in an earlier blog, you can use the method shown in this blog instead.

This blog is part of a complete Excel VBA tutorial.

Even if you're writing Visual Basic macros within Excel, there's nothing to stop you inserting text into Word documents, manipulating PowerPoint slides or sending Outlook emails. This blog explains how to reference other applications, and write macros in Excel to link to other Microsoft Office software

This blog is part of a complete Excel VBA tutorial.