Export To Excel got "Exception error"

24 Apr 2006 6:20 AM

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.(EXCEPTION FROM HRESULT :
0X80020011(DISP_E_NOTACOLLECTION)

I am using Excel10.0 libary .

Does anyknow know what's wrong ?
thanks
From AGnes

24 Apr 2006 7:34 AM

Agnes

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

Show quoteHide quote

"Agnes" <ag***@dynamictech.com.hk> ¼¶¼g©ó¶l¥ó·s»D:uLQHsb2ZGHA.4***@TK2MSFTNGP05.phx.gbl...
> 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.(EXCEPTION FROM HRESULT :
> 0X80020011(DISP_E_NOTACOLLECTION)
>
> I am using Excel10.0 libary .
>
> Does anyknow know what's wrong ?
> thanks
> From AGnes
>
>

24 Apr 2006 10:04 PM

vbnetdev

try

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

--
Get a powerful web, database, application, and email hosting with KJM
Solutions
http://www.kjmsolutions.com

Show quoteHide quote

"Agnes" <ag***@dynamictech.com.hk> wrote in message
news:uLQHsb2ZGHA.4936@TK2MSFTNGP05.phx.gbl...
> 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.(EXCEPTION FROM HRESULT :
> 0X80020011(DISP_E_NOTACOLLECTION)
>
> I am using Excel10.0 libary .
>
> Does anyknow know what's wrong ?
> thanks
> From AGnes
>
>