Chart vanishes in Excel 2010

[paras@18583]

Hello

I haven't seen an answer to this, but if it’s been already posted, please point me in the direction...

Recently our systems were upgraded to MS office 2010 from MS office 2003. Due to migration some of the codes written in Excel 2003 are not working properly in Excel 2010. We prepare all our reports on Excel. Just to give brief background on what code does-

- We have a set template of the report, where code is written. For explanation purpose let’s call this spreadsheet as “Spreadsheet ABC”. This file is always in the read only mode.

- Before generating the report, the user has to give path of the different working spreadsheet (lets call this as “Source spreadsheet”) in the Spreadsheet ABC.

- Then user has to hit the command button in Spreadsheet ABC, which in turn would pull charts and data from the different Source spreadsheet to the set template in Spreadsheet ABC..

- Then code would transfer all data from Spreadsheet ABC into new blank spreadsheet and would save this file at a specific location.

The code works absolutely fine till third step for pulling charts and data from different sources. However, in the fourth step while transferring charts and data into new spreadsheet the chart doesn’t get pasted (rest of the data gets pasted though).

All the files containing data and charts are created in Excel 2003. And this code works absolutely fine when run in Excel 2003. So can somebody help me on solving this problem, please?

Thanks in advance.

[paras@18583]

Couple of lines where code fails are-

ActiveSheet.Select
ActiveSheet.Copy

ActiveSheet.SaveAs Filename:=sFile

Where sFile is the name of the file along with location.

Activesheet.Copy does creates a replica of the template but without charts.

Are these charts not getting pasted because they were created in Excel 2003?