ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   =Why AddIns.Installed can be out of range= (https://www.excelbanter.com/excel-programming/311101-%3Dwhy-addins-installed-can-out-range%3D.html)

hcova[_2_]

=Why AddIns.Installed can be out of range=
 
I am trying to verify if the Analysis Tollpak is installed with the following
sentence:

If AddIns("Analysis ToolPak").Installed = False Then
MsgBox "Analysis ToolPak is not installed"
End If

The problem is that I receive a error when I run this code. In the first
line, VBA stops telling me "Subindex out of interval", making reference to
the string argument.
If I replace the argument of the AddIns property by for example an 1, I
don“t receive the error box. It works!!. However, if you check the online
help there are many examples where the AddIns property can accept strings and
numbers as argument.
Where I am making the error?







All times are GMT +1. The time now is 12:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com