Reports -Excel 2003 to excel 2007 conversion

[spothineni]

Hi,

Recently my project reports upgarded from excel 2003 to excel 2007 and seeing some issues related to object model.

My reports were good with excel 2003 but not with 2007.we have integrated with .NET project.

Giving errors at below lines of code.

chart.ApplyCustomType((Excel.XlChartType)(21),"Lines on 2 Axes");

xAxis.CategoryType = Excel.XlCategoryType.xlTimeScale;
xAxis.BaseUnit = Excel.XlTimeUnit.xlDays;
xAxis.MajorUnitScale = Excel.XlTimeUnit.xlDays;

Please help me ASAP. I would really appriciate your time.

Thanks.