topic Re: Vbmacro for exporting 2 listbox and one pivot table? in QlikView https://community.qlik.com/t5/QlikView/Vbmacro-for-exporting-2-listbox-and-one-pivot-table/m-p/722689#M259419 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A href="https://community.qlik.com/docs/DOC-3481">VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Field Value</A></P></BODY></HTML> Tue, 30 Sep 2014 04:59:10 GMT tresB 2014-09-30T04:59:10Z Vbmacro for exporting 2 listbox and one pivot table? https://community.qlik.com/t5/QlikView/Vbmacro-for-exporting-2-listbox-and-one-pivot-table/m-p/722688#M259418 <HTML><HEAD></HEAD><BODY><P>hi have </P><P></P><P>two list boxes </P><P>one is country and second one is city</P><P>third object pivot table</P><P>now if i select one country in list box i want export all the city data into single excel file with each sheet contain each city pivot table data sheet name renamed with city name.</P><P>and same for all the countrys</P><P></P><P>please help me on that if any vb script code please share tahnks</P></BODY></HTML> Tue, 30 Sep 2014 04:53:21 GMT https://community.qlik.com/t5/QlikView/Vbmacro-for-exporting-2-listbox-and-one-pivot-table/m-p/722688#M259418 2014-09-30T04:53:21Z Re: Vbmacro for exporting 2 listbox and one pivot table? https://community.qlik.com/t5/QlikView/Vbmacro-for-exporting-2-listbox-and-one-pivot-table/m-p/722689#M259419 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A href="https://community.qlik.com/docs/DOC-3481">VB Macro to Loop (User-Defined) Field and Export (User-Defined) Chart to Excel and Name Sheets by Field Value</A></P></BODY></HTML> Tue, 30 Sep 2014 04:59:10 GMT https://community.qlik.com/t5/QlikView/Vbmacro-for-exporting-2-listbox-and-one-pivot-table/m-p/722689#M259419 tresB 2014-09-30T04:59:10Z