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!