topic Re: Macro add column data to existing Excel in QlikView

Macro add column data to existing Excel

r_vdbraak — Mon, 19 Oct 2020 13:00:59 GMT

Dear Qlikview users,

I've seen many scripts for adding a data row from a Qlikview chart to an existing Excel.

But I want to add a data column to an existing Excel.

Who can help me with such a macro script

Thanks in advance for thinking along.

Richard

Re: Macro add column data to existing Excel

Brett_Bleess — Tue, 27 Oct 2020 20:42:44 GMT

This is something that would be better addressed in the Microsoft Excel forums, as those folks would be the experts as far as the necessary Excel APIs needed etc. If you need any QlikView APIs, you will find those in a QVW file from the following link:

https://help.qlik.com/en-US/qlikview-developer/April2020/Subsystems/Automation/Content/QV_Automation/APIGuide/QlikViewComApiGuide.zip

Regards,
Brett