date and VB

[Guest]

If I have a date configured out of text and put this value into a
button.caption the date is given correctly. But if i take this value and put
it from the button on the form to excel sheet a proble occurs:

20th of august 2005 on button = 20-8-05 and in excell as well
10th of august on button = 10=8-05 and in excell sheet it is 8-10-05 with
cells dd-mm-jj.

Anyone has a solution /?
C

 

[Jim Rech]

Stephen Bullen wrote a whole chapter on international issues in the book
"Excel 2002 VBA" he co-authored (Wrox). There he discusses how problems
like yours come about because VBA "speaks American" even in non-American
locales. His advice is not to send Excel literal strings from VBA but to
first convert them to the date type you want. For a date one way would be:

Range("A1").Value = DateSerial(2005, 8, 10)

so you'd have to parse the text on the button into its three date
components.

--
Jim
| If I have a date configured out of text and put this value into a
| button.caption the date is given correctly. But if i take this value and
put
| it from the button on the form to excel sheet a proble occurs:
|
| 20th of august 2005 on button = 20-8-05 and in excell as well
| 10th of august on button = 10=8-05 and in excell sheet it is 8-10-05 with
| cells dd-mm-jj.
|
| Anyone has a solution /?
| C