Date Format Changes US vs. EU

Hi all,

I have a problem.
Ive Created a script witch simply copy's a mail to Excel but these mails contain date's.
The normal format of my pc = "d/m/yyyy" (regional and language settings)
My Excel format again = "d/m/yyyy"
My Office i maight add is English US (maybe this is the problem)
And still when i run the script excel just converts it to "m/d/yyyy".
In excel there is some code that adds days to the date so i need the date setting else i just format the cells to "text".

Ive looked at almost every site listed in google about this problem but i cant seem to find a real solution just work arounds that dont aply.

Thnx in advance

Whenm you transfer a string 'date' to an Excel cell, use DateValue to convert to a proper numeric date according to your Regional Settings so:

Range("A1").Value = DateValue(strMyDate)

PHP Code: 

Sub OpenMailinExcel()
Dim myitem As Object
Dim myOlApp As New Outlook.Application
Dim myOlExp As Outlook.Explorer
Dim myOlSel As Outlook.Selection
Dim MyData As DataObject
Set MyData = New DataObject
Set myOlExp = myOlApp.ActiveExplorer
Set myOlSel = myOlExp.Selection
For Each myitem In myOlSel
    MyData.SetText myitem.Body
    MyData.PutInClipboard
    Dim xlApp As Object
    Dim xlWkb As Object
    Set xlApp = CreateObject("Excel.Application")
    xlApp.Visible = True

    xlApp.Workbooks.Open FileName:="C:\Documents and Settings\js0000283\My Documents\m4u factuur.xlsm", ReadOnly:=True
    
    xlApp.Worksheets("Mail").Select
    xlApp.Range("A1").Select
    xlApp.Activesheet.Paste
Next
End Sub 


This is in outlook

Is the information you are extracting from Outlook just dates or do you extract other information too (whether numeric values, words or whatever)?

Just 1 date but there's more tekst