Export To Excel got "Exception error"

[Agnes]

Same application, When use the dataset expor to EXCEL, work very well.
However, for some PC I will got the following error
"DOES NOT SUPPORT A COLLECTION.(EXC EPTION FROM HRESULT :
0X80020011(DISP _E_NOTACOLLECTI ON)

I am using Excel10.0 libary .

Does anyknow know what's wrong ?
thanks
From AGnes

[Agnes]

Re: Export To Excel got "Except ion error"

I find the problem, some PC is using ver2000 (so , they can't export to
excel)
some PC is using ver2003 (everything go fines)

"Agnes" <agnes@dynamict ech.com.hk> ¼¶¼g©ó¶l¥ó·s»D: uLQHsb2ZGHA.493 6@TK2MSFTNGP05. phx.gbl...[color=blue]
> Same application, When use the dataset expor to EXCEL, work very well.
> However, for some PC I will got the following error
> "DOES NOT SUPPORT A COLLECTION.(EXC EPTION FROM HRESULT :
> 0X80020011(DISP _E_NOTACOLLECTI ON)
>
> I am using Excel10.0 libary .
>
> Does anyknow know what's wrong ?
> thanks
> From AGnes
>
>[/color]

[vbnetdev]

Re: Export To Excel got &quot;Except ion error&quot;

try

http://www.kjmsolutions.com/datasetarray.htm

--
Get a powerful web, database, application, and email hosting with KJM
Solutions

http://www.kjmsolutions.com

"Agnes" <agnes@dynamict ech.com.hk> wrote in message
news:uLQHsb2ZGH A.4936@TK2MSFTN GP05.phx.gbl...[color=blue]
> Same application, When use the dataset expor to EXCEL, work very well.
> However, for some PC I will got the following error
> "DOES NOT SUPPORT A COLLECTION.(EXC EPTION FROM HRESULT :
> 0X80020011(DISP _E_NOTACOLLECTI ON)
>
> I am using Excel10.0 libary .
>
> Does anyknow know what's wrong ?
> thanks
> From AGnes
>
>[/color]