Export chart in an opened Excel workbook

[#1]

Hi everyone,

I 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

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 ExportBiff.

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.

Unfortunately, the command ExportBiff only works when the workbook is closed...

I have no idea how to do this so any help is welcome !

Hope that I have been understandable.

Thanks in advance !