2 Replies Latest reply: Feb 21, 2013 11:52 AM by ben.khalek RSS

    Help with Excel Export

      Hello all,

       

      I am new to QlikView and VB Scripting. I have a sheet with several Conditional Hidden fields, and different data displays depending on values selected. I am putting an Excel Export button on the sheet to export the data that is visible at the time, however I am not sure of how to set up the VBScript syntax in order to only grab only the fields that are visible. Is there any functionality or parameter I can use in an If condition to get what I need?

       

      *if field Id is visible = true * <-- How do i do this???

      Then

      ActiveDocument.GetSheetObject("field Id").CopyTableToClipboard true

      XLApp.Worksheets(1).Range("A1").Select()

      XLApp.Worksheets(1).Paste()

       

      Thank you.

       

      BK