Date retrieve incorrectly

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

vba array logic 3
Multi-Dimensional Array Procedures 2
Transferring a Date array to a range 6
Multi Dimensional Array 4
Find a date in list less or equal than target date 4
Creating and transposing a multiarray 3
Problems with application.worksheetfunction.correl 3
Returning an array from a multi-dimensional array 2

Back
Top