Installing an Addin

[Giordano Bruno]

I have the following code (Called from another macro)

On Error Resume Next
Addins("ACME").Installed = True

The code stops at the second line with a Run-time eror 9 Subscript out of range.

The file ACME.xlam is visible in the VBA Project window.

Question 1. Why does the code not resume next.

Question 2. Why does the code create an error

I'm using Excel 2007

Any suggestions will be gratefully received.

 

[Giordano Bruno]

Just to add to the above, If I stop the code at the point where the error occurs and re-run the macro, the Addin is installed properly.

If I make a second macro which does nothing but call the first macro, the error returns.

It seems that the problem occurs only when the Addin macro is called from another macro.

 

[Giordano Bruno]

This thread is becoming a mess. Ignore the second post.

What happens is that although the code stops; if I click End instead of Debug the Addin is ticked, despite the error message. When the addin is ticked, the code runs past that line without stopping. It seems that all I need is a method of getting past the error without the message stopping the code.