| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| the date value of series is incorrectly displayed | Charts and Charting in Excel | |||
| Date format diplays incorrectly | Excel Worksheet Functions | |||
| Web Query Pulling Date Incorrectly. | Excel Discussion (Misc queries) | |||
| Date columns are formatted incorrectly on export to excel | Excel Discussion (Misc queries) | |||
| date in Excel displays incorrectly when merged in letter | Excel Discussion (Misc queries) | |||
![Michael Garcia[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
