topic How can I export another sheet object "CH03" ... in QlikView

How can I export another sheet object "CH03" ...

anilkumarmishra — Wed, 25 Nov 2020 16:16:04 GMT

Dear All,

I have two sheet objects "CH01" & "CH03" & I want to export data of both sheet objects into two different excel files in the different locations but in the below macro code I am able to export "CH01" into excel file using

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff "D:\MAIL ALERTS\Opti_Customer_Invoice_Mail_Alert\" & Parent_name.Item(0).Text &"-"& Temp(i).Text & ".xls"

How can I export another sheet object "CH03" into obj & export into excel file ?

I have tried to use the following ..but it is not working..

set obj = ActiveDocument.GetSheetObject("CH01")

'obj.ExportBiff "D:\MAIL ALERTS\Opti_Customer_Invoice_Mail_Alert\" & Parent_name.Item(0).Text &"-"& Temp(i).Text & ".xls"

set obj = ActiveDocument.GetSheetObject("CH03")

obj.ExportBiff "D:\ZZ\" & Parent_name.Item(0).Text &"-"& Temp(i).Text & ".xls"

Please suggest with example...

With thanks & regards..

AKM

Re: How can I export another sheet object "CH03" ...

tamilarasu — Wed, 28 Feb 2018 08:09:12 GMT

Hi Anil,

Could you explain us what is the purpose of below statements?

Parent_name.Item(0).Text & Temp(i).Text

Re: How can I export another sheet object "CH03" ...

anilkumarmishra — Mon, 05 Mar 2018 05:03:19 GMT

Dear Sir,

Thanks for the response.

Parent_name is name of a field . Please ignore it.

Regards,

AKM

Re: How can I export another sheet object "CH03" ...

tamilarasu — Mon, 05 Mar 2018 05:25:14 GMT

Hi Anil,

Have a look at the below attached file and let me know if you still have any issues.