View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jerry W. Lewis Jerry W. Lewis is offline
external usenet poster
 
Posts: 16
Default Decimal type in Excel 97

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.