topic Export chart in an opened Excel workbook in QlikView https://community.qlik.com/t5/QlikView/Export-chart-in-an-opened-Excel-workbook/m-p/1224387#M391028 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">am a beginner in QlikView and what's more a French guy trying to be understandable to the community, so please be lenient with me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P></P><P>Thanks to an external VBScript, I am trying to export a chart from QlikView to an Excel workbook I just opened (so not saved yet) using the command <STRONG>ExportBiff</STRONG>.</P><P>More specifically, I would like to open an Excel workbook, export my chart from QlikView to this workbook, [copy the data I want from this workbook to another file], and then close this workbook without saving it.</P><P>Unfortunately, the command <STRONG style="font-size: 13.3333px;">ExportBiff </STRONG>only works when the workbook is closed... </P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have no idea how to do this so any help is welcome !<SPAN class="emoticon-inline emoticon_happy" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hope that I have been understandable. <SPAN class="emoticon-inline emoticon_wink" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks in advance !</P></BODY></HTML> Thu, 22 Dec 2016 11:20:34 GMT 2016-12-22T11:20:34Z Export chart in an opened Excel workbook https://community.qlik.com/t5/QlikView/Export-chart-in-an-opened-Excel-workbook/m-p/1224387#M391028 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">am a beginner in QlikView and what's more a French guy trying to be understandable to the community, so please be lenient with me <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></SPAN></P><P></P><P>Thanks to an external VBScript, I am trying to export a chart from QlikView to an Excel workbook I just opened (so not saved yet) using the command <STRONG>ExportBiff</STRONG>.</P><P>More specifically, I would like to open an Excel workbook, export my chart from QlikView to this workbook, [copy the data I want from this workbook to another file], and then close this workbook without saving it.</P><P>Unfortunately, the command <STRONG style="font-size: 13.3333px;">ExportBiff </STRONG>only works when the workbook is closed... </P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have no idea how to do this so any help is welcome !<SPAN class="emoticon-inline emoticon_happy" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hope that I have been understandable. <SPAN class="emoticon-inline emoticon_wink" style="font-weight: inherit; font-style: inherit; font-family: inherit;"></SPAN></P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks in advance !</P></BODY></HTML> Thu, 22 Dec 2016 11:20:34 GMT https://community.qlik.com/t5/QlikView/Export-chart-in-an-opened-Excel-workbook/m-p/1224387#M391028 2016-12-22T11:20:34Z