Creating multiple Charts in excel sheet

HCL Domino Domino Forum
1

Hi,

I am trying to create multiple Charts in an excel sheet. I wrote the following script but I receive this error msg “Variant does not contain an object”.

Count=3

For i=1 To Count

xlWorkbook.Charts(i).Copy ,xlWorkbook.Charts(i)

Next

Is there a way to create multiple Charts or Worksheets in a loop. Please advice