ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Date retrieve incorrectly (https://www.excelbanter.com/excel-programming/320661-date-retrieve-incorrectly.html)

Michael Garcia[_2_]

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

Michael Garcia[_2_]

Date retrieve incorrectly
 
I'm an idiot...problem fixed.

"Michael Garcia" wrote:

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



All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com