Office 2003 and Date Issue

N

niel

A macro has stopped operating correctly when a client updated to Office
2003. Trhough VBA, when copying from one workbook and pasting to another a
UK date is being converted to US format when pasted. Appears to be a bug.
E.g. 10/04/2006 being converted to 04/10/2006. This then reads as 4 October
2006 which is incorrent. The only thing that has changed on the relevant
machine is that Office 2003 has been installed.Any ideas!

Code Equivalent

rngBK1.Copy
rngBK2.Paste

Thanks in advance
 
D

Dave Peterson

Before you do too much more work, try formatting rngbk1 in an unambiguous
format--MMMM DD, YYYY (for example).

I'm guessing that the dates are the same, but the formatting isn't.

If that's not the case, you may want to post the actual code--not the code
equivalent.
 
Top