Tim,

What does your code look like? If you can get the text from the clipboard
then you might be able to extract the date and format it as you want....

Tim


"Tim Childs" wrote in message
...
Hi from Europe!

I am using VBA to paste a clipboard filled with figures and dates from a
Web
page but the VBA is altering 7 March 2006 (07/03/06) to 3 July 2006
(03/07/2006). This only happens in VB code - when pasting manually the
date
is pasted fine.

I have searched the newsgroups but the only solution seems to be to use
Excel 2002 which I don't have.

The date is always in the third column of the clipboard - is it possible
to
interrogate the clipboard? Are there any other avenues to explore?

Thanks in advance

Tim