Exporting to multiple Tabs of the same Excel file

[vlad_komarov]

Hi,

I am exporting some of my tables to Excel using the following:

set objExport = ActiveDocument.GetSheetObject("CH24")

objExport.ExportEx fileName1,5

set objExport = ActiveDocument.GetSheetObject("CH59")

objExport.ExportEx fileName2,5

Is it possible to create multiple tabs in the same Excel file and export each chart to separate tabs, and not separate files like above?

Looking forward to suggestions.

Best regards,

Vladimir

[shanmurugesh]

Hi rebeccad

It is working great, but i'm facing one small issue, i unable to load more than 3 sheets in single excel.

could you please help?

Note:

there are two set of file

first one is with 2 sheet - it is working fine

Second one is with 4 sheet -it is not working properly.

and also check "Current local security"  before run the macro..

Thanks and regards,

Murugesan.N

[askarkhan]

hi,

This is very useful macro which you have shared. any how i am getting an error please help me out with this.

please see attchment for error. i am geting error in line

XLDoc.Sheets(2).Paste() 

please have a look and get a solution for me.

Thank you!