7 Replies Latest reply: Dec 22, 2015 12:30 AM by Prasanna Sankepalli RSS

    How to get Active Sheet ID and object id  to QlikView Macro

    Prasanna Sankepalli

      Hello Experts,

       

      I am writing macro for my Qlikview application. there I have a scenario like below.

       

      I need to find the Active sheet (SH01) , from there if Obj id (TXT01) is Active then my macro need to show message.

       

       

      Sub Test

       

      if ActiveDocument.ActiveSheet.GetProperties.SheetId="Document\SH14" and ActiveDocument.ActiveSheet.SheetObjects("Document\TX17").isactive then  MsgBox "Test Success"

       

      end sub

       

       

      but I am getting the error at ActiveDocument.ActiveSheet.SheetObjects("Document\TX17").isactive.

       

      Please let me know how to check for particular text object is active or not

       

       

      Thanks

      KR