topic how to export the variable in to excel? in QlikView https://community.qlik.com/t5/QlikView/how-to-export-the-variable-in-to-excel/m-p/278629#M103731 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have one problem. i have totasl 6 variable,can i export these varible in to excel excel using macro.</P></BODY></HTML> Mon, 16 Jan 2012 11:41:34 GMT 2012-01-16T11:41:34Z how to export the variable in to excel? https://community.qlik.com/t5/QlikView/how-to-export-the-variable-in-to-excel/m-p/278629#M103731 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have one problem. i have totasl 6 variable,can i export these varible in to excel excel using macro.</P></BODY></HTML> Mon, 16 Jan 2012 11:41:34 GMT https://community.qlik.com/t5/QlikView/how-to-export-the-variable-in-to-excel/m-p/278629#M103731 2012-01-16T11:41:34Z how to export the variable in to excel? https://community.qlik.com/t5/QlikView/how-to-export-the-variable-in-to-excel/m-p/278630#M103732 <HTML><HEAD></HEAD><BODY><P> <SPAN style="font-size: 8pt;"> </SPAN></P><P><SPAN style="font-size: 8pt;"></SPAN></P><P>set v = ActiveDocument.Variables("YourVariable")<BR />strYourVariable = v.Getcontent.String <BR />Set XLApp = CreateObject("Excel.Application")<BR />XLApp.Visible = True <BR />Set XLWorkbook = XLApp.Workbooks.Add</P><P></P><P>Set XLSheet = XLWorkbook.sheets("Sheet1")<BR />XLSheet.Select</P><P></P><P></P><P></P><P></P><P></P><P>XLSheet.Range("A1").Value = strYourVariable</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P></BODY></HTML> Mon, 16 Jan 2012 12:09:06 GMT https://community.qlik.com/t5/QlikView/how-to-export-the-variable-in-to-excel/m-p/278630#M103732 m_woolf 2012-01-16T12:09:06Z