SQL Excel

Tag it:

Delicious

Furl it!

Spurl

NewsVine

Reddit

YahooMyWeb

?

The add-in is a COM add-in.   Basically an ActiveX DLL.  This DLL needs to be registered on the users machine.  The core functionality of the installation process is actually the registration of this DLL.

Microsoft introduced COM for Office with Office 2000.

Advantages of a COM add-in over a traditional VBA Add-in are the following

• Runs Faster - the code is compiled as opposed to VBA's script style
• Better security
  
• Smaller distribution - compiled format gives smaller file size for easier / faster distribution
• Makes use of Seperate Threading - each COM Add-in is given its own execution thread
• Can be used in all Office Applications (this particular add-in was built for Excel but could be easily modified to work with Word or access)