date problem in excel

[coolily]

in my excel spreadsheet i used format of dd/mmm
and internally excel has stored it as mm/dd/yyyy.

i then used this column to populate the combobox in vb. the combobox gets populated with the internal format of mm/dd/yyyy.

but when i read the whole column back to display it in a listbox, i get error.
i guess the error is due to the difference in formats. can anyone help suggesting anything please?????

[valkyrie]

Hi,
Correct me if I'm wrong here, but most of Mr Bill's software follow the Windows short date format. So check it out first, and I do believe that VB is running on the short date format.
I've used a reporting application which was built with VB, and we had another application interfacing with this, which had a date format of "yyyy/mm/dd" while the program had the format "dd/mm/yyyy". When the application was executed to print out the report, we found that the date field was missing, so, we changed the short date format to follow "yyyy/mm/dd" and the problem was solved!!
Check it out... hope this helps

____________________________________
The VB Bugs in my Life...