Is this possible via VBA?

I cant figure it out :)

    AddIns("ODBC Add-in").Installed = False
    AddIns("ODBC Add-in").Installed = true

cheers

Matt

excellent thanks for that, that sorted that problem!

How do i add an addin if it doesnt exist in their list of addins?

Something like:

if addins("Budgets").exist = false then
add the addin to the list
end if

Anyone know the code for this?

Set myAddIn = AddIns.Add(Filename:="C:\MYADDIN.XLA", CopyFile:=True)

cheers

Matt

cheers i will give that a go

How do i check whether it exists in their addins list? The installed switch just checks whether its checked in the list

Sub enableAddIn()
On Error Resume Next
    myAddInName = "MYADDIN"
    AddIns(myAddInName).Installed = True
    Debug.Print Err.Number & " - " & Err.description
    If Err.Number <> 0 Then
        Set myAddIn = AddIns.Add(Filename:="C:\" & myAddInName & ".XLA", CopyFile:=True)
        AddIns(myAddInName).Installed = True
    End If
On Error GoTo 0
End Sub

should work...
cheers

Matt

thanks for that matt, it worked a treat :)