Titus Classification selection using VBA

    Hi There,


    Anyone can please help me on selecting the Titus Classification(Comm Addin) using a VBA, and when i tried using the sendkeys it didnt work.


    when the macro is running to select any option in the classification using send keys, the options are acyually invisible in the Command bar.


    Am struggling from 1 week just scratching my head to find a resolution for this one.:(:(


    Please help me out, Thanks in Advance...!!!:):)

    Hi,


    If my understanding is correct, you need to enable your Add-In with VBA ...


    You could test following


    Code
    Public Sub Connect_COM_AddIn(Name As String)
' Use your Titus Classification as the Name
    Dim ndx As Integer
    For ndx = 1 To Application.COMAddIns.Count
        If Application.COMAddIns(ndx).Description = Name Then
            Application.COMAddIns(ndx).Connect = True
            Exit For
        End If
    Next ndx
End Sub

    Hope this will help

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

    (TitusClassificationForOffice.Connect or TITUS Classification for Microsoft Office) is the name of my Titus and VBA is not allowing me to add this into Name

    You are welcome

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login