Office 2003 and Date Issue

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

niel - 11 Apr 2006 08:41 GMT

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

Reply to this Message

Dave Peterson - 11 Apr 2006 13:06 GMT

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.

> 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
[quoted text clipped - 9 lines]
>
> Thanks in advance

Signature

Dave Peterson

Reply to this Message