View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Michael Garcia[_2_] Michael Garcia[_2_] is offline
external usenet poster
 
Posts: 2
Default Date retrieve incorrectly

I am setting a multi dimensional array equal to a range. All the data is
being retrieved correctly with the exception of the columns containing dates.

I am using VB.Net and automation to access the spreadsheet. When I debug
and inspect the contents of the array, the date is being cast to an integer.
All dates are showing the value of 7.

Anyone have any ideas?

Thanks in advance.

Mike