Excel 2003 Add-In Automation

[MacroMan]

What is the "Automation" button in Excel's Add-In dialog box? What
does it do? What is it good for and how does it differ or relate to
"Add-Ins?" I would like to use/try it (to improve my Excel skills),
but I find no documentation as how to use it.

The only thing I find in the help documentation from Excel is: "You
can click the Automation button to list all Component Object Model
(COM) add-ins available to load into Excel."

Wow. That doesn't help.

Any knowledgable direction would be much appreciated...

 

[JLGWhiz]

Maybe if it said that by clicking the Automation button it would display a
menu of COM add-ins that are available for download, if you want to download
them, it would make more sense?

 

[Norman Jones]

Hi MacroMan,

Chip Pearson provides detailed informatio
on his Automation Add-in page at:

Automation Add Ins As Functions Libraries
For Excel And VBA
http://www.cpearson.com/excel/AutomationAddIns.aspx