Macro paste to web form in wrong date format

[ClimoC]

Hello,
My macro takes the value of a range of dates in dd/mm/yy format, and puts the date into a text field of a web form in IE, (also does some other copying-pasting)then submits the form. Problem is it pastes in American format - mm/dd/yy and this is incorrect for the webform.

I've tried manually typing the date into the field (as oppose to using the javascript calendar on the text field) and submitted, and the date is fine.

It is during the process of going from Excel to IE that the dates all get their numberformatting switched.

How can I tell excel to keep the numberformat as "dd/mm/yy"? I have been told that Office 2007 hates English dd/mm/yy format, but I'm in Excel 2003

Any help would be much appreciated

the bit where it assigns the value of the cell in the range is here (fields that are in dd/mm/yy numberformat are RED:

If TestcheckBox = True Then
        ProTitle = Range("I" & R).Value
        DurationTime = Range("Z" & R).Value
        TransStart = Range("M" & R).Value
        TransEnd = Range("M" & R).Value + 1
        LineTX = Left(Range("L" & R).Value, 9)
        VisFrom = Range("N" & R).Value
        VisTo = Range("P" & R).Value

 

[Norie]

If the 'date' is formatted as you want use Text not Value.

 

[ClimoC]

Stunner!

One thing - the line that reads Range("M" & ReviewRow).Value +1

In other words that which takes a date and adds one day onto it.

How do I still do this "+1" element and make it text?

Cheers
C

 

[Norie]

There is no line that reads like that in your posted code.

 

[ClimoC]

I beg your pardon - it's Range("M" & R).Value +1

R is set as reviewrow earlier in the code