Macro in Qlikview

dinuwanbr · ‎2016-07-25

Dear all,

I have a table to get an excel sheet as output. There's a selection box and based on the values of that i want to loop that excel outputs(csv or qvd also ok).

Can anyone help me on this.

Rgds,

Tharindu

vikasmahajan · ‎2016-07-25

May be this

set obj = ActiveDocument.GetSheetObject("CH703")

obj.ExportEx "E:\Qlikview\Department_Loadinng.xls",

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

susovan · ‎2016-07-25

Hi,

Is it your requirement?

So, please check the attachment.

Warm Regards,
Susovan

Gysbert_Wassenaar · ‎2016-07-25

Perhaps this document helps: Loop Charts and Field Values - Excel Export Macro

talk is cheap, supply exceeds demand

Related Topics