Data from an un opened Addin

[Giordano Bruno]

I have an addin file that may or may not be ticked as the code is run. The file has an intranet address written in cell B2.

I need some code to discover the intranet address without opening (ticking) the addin. The addin exists on numerous different computers so I cannot 'hard wire' the address.

Is this possible? Any assistance will be gratefully received.

 

[Giordano Bruno]

I have found a backdoor solution to this which involves finding the path and then creating a formula to link to the file.

Sub FindVerNum()
Dim x, y, z
Range("A1").ClearContents
x = Application.UserLibraryPath
x = "='" & x & "[swxy.xla]Sheet1'!$A$2"
Range("A1").Value = x
End Sub

It behaves rather strangly when I delete the Addin. Although the addin is deleted, and the code clears the cells, the macro still returns the original value. I have to break links AND save before it realizes there is nothing there.

If anyone can throw any light on this I would be grateful.