chart.ChartWizard always failed in excel2k7
 

For exmaple,

chart.ChartWizard(range5, XlChartType.xl3DColumn, Missing.Value,
XlRowCol.xlRows, 0, 0, True, "Chart", _"Category Type", "Value Type")

the above code worked well in excel 2k3, but always got exception in excel
2k7.

The exception was,

Unhandled Exception: System.Runtime.InteropServices.COMException
(0x80020005): T
ype mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
at
Microsoft.VisualBasic.CompilerServices.LateBinding .InternalLateCall(Object
o, Type objType, String name, Object[] args, String[] paramnames, Boolean[]
Cop
yBack, Boolean IgnoreReturn)
at Microsoft.VisualBasic.CompilerServices.NewLateBind ing.LateCall(Object
Inst
ance, Type Type, String MemberName, Object[] Arguments, String[]
ArgumentNames,
Type[] TypeArguments, Boolean[] CopyBack, Boolean IgnoreReturn)
at AutoExcel.AutoExcel.Main()


This got me stuck at it. sigh...

can somebody help me? thx.