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

[anilkumarmishra]

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

[tamilarasu]

Hi Anil,

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

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

[anilkumarmishra]

Dear Sir,

Thanks for the response.

Parent_name is name of a field . Please ignore it.

Regards,

AKM

[tamilarasu]

Hi Anil,

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