2 Replies Latest reply: Apr 13, 2016 2:10 AM by Perumal Ayyappan RSS

    Reading Value of variable in Macro

      Hi Community,



      I have a situation where a QV variable is stored to retrieve the selected chart. as below:


      Example: vGraph = if(Graph='Line', CH01,

                                         If(Graph='Bar', 'CH02')


      vGraph is a QV variable.


      I am trying to export the chart to excel and trying to implement the value of selection of graph here.


      So instead of GetSheetObject(qvObjectId). Can i use  ActiveDocument.GetVariable("vGraph ") in macro ?? So as to get the get sheet Object ID




      Thanks in advance.