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