I am creating an vb.net application that uses Excel 97 to generate xls reports.

I create an array object that contains dot.net decimal types and pass that
array object into a range object from Excel 97, would errors occur? I ask
because I get 0x800A03EC when setting a range objects value method to the
data array I created.


Thank you in advance for your assistance.

You must explicitly coerce from decimal to double before putting them into a
range object.

Jerry

"E-Cube" wrote:

I am creating an vb.net application that uses Excel 97 to generate xls reports.

I create an array object that contains dot.net decimal types and pass that
array object into a range object from Excel 97, would errors occur? I ask
because I get 0x800A03EC when setting a range objects value method to the
data array I created.


Thank you in advance for your assistance.

Jerry,

Thank you that worked.

Eric

"Jerry W. Lewis" wrote:

You must explicitly coerce from decimal to double before putting them into a
range object.

Jerry

"E-Cube" wrote:

I am creating an vb.net application that uses Excel 97 to generate xls reports.

I create an array object that contains dot.net decimal types and pass that
array object into a range object from Excel 97, would errors occur? I ask
because I get 0x800A03EC when setting a range objects value method to the
data array I created.


Thank you in advance for your assistance.