is it possible to make reference to a xla file using vba ?

Posted by lkcmbp on July 11, 2001 3:07 AM

Hello, if i use a function in a xla file, it must be referenced first in the workbook that use it. If this book doesn't have this reference yet, is it possible to add it by using VBA ?

Thanks.

Posted by Ivan F Moala on July 11, 2001 3:30 AM

Via code eg using Analysis toolpak addin
AddIns("Analysis ToolPak").Installed = True

or in your project just reference the addin
in the explorer view.

Ivan