I am transferring data from Word reports. This includes date information. The word date is ddd dd-mm-yyyy (e.g. MON 10-06-2013
I run code to extract the month, and the correct month is extracted (from example, June).
However, when I get to extracting the actual date it doesn't work and converts to American format- form the example, the cell contents become 06/10/2013. I am aware of that problem and have built in code to handle it, but it is only doing so intermittently. Even if I then manually change the cell formatting, it remains the same.
Dim WordDate As Variant
WordDate = wdDoc.FormFields("Date").Result
WordDate = Right(WordDate, 10)
WordDate = CDate(WordDate)
WordDate = Format(WordDate, "dd/mm/yyyy")
Cells(NextRow, "r") = Format(WordDate, "dd/mm/yyy")
Thanks in advance.