excel object late binding

[Signo.X]

when using late binding to manipulate an excel document , do i need to add a reference to the library ' 'MS Excel object library 11.0' in my project ?

~signo.X

 

[JohnH]

No you don't do that. (unless you code some early bind first and change it later to Object and late bind, you should make copies of project if you want to do this anyway)

 

[Signo.X]

but it gives me errors when i try to use some of the Excel.chart properties..
e.g.
'select chart type
oChart.ChartType = XlChartType.xlColumnClustered

how do i fix that ?

 

[JohnH]

You have to replace Excel's built-in constants with integer equivalents or declare them yourself. Late binding don't come easy.

 

[Signo.X]

Thanks JohnH