Tim

I did try out the pasting into text-formated cells but it did not do
the trick.

I intend though to use the idea it gave of pasting the clipboard as
text itself and then interrogating the result to find the "true" date

Thanks very much for your help

Tim



Tim Williams wrote:
Tim,

A lot of code so I admit I didn't take the time to figure it all out. A few
questions though...

Have you tried formatting the paste area as text before pasting the copied
text?
What happened when you pasted as HTML?
Is the format of the page you're copying from consistent? Are you copying
an entire table's contents and is that table in a consistent place on the
page? If so, you might be better off using IE automation and the HTML
document object model to read the data directly off the web page.

If you're still having problems feel free to e-mail me (tim j williams at
gmail dot com: no spaces). I can't promise immediate attention, but I might
be able to help given more details of what you're attempting....


Cheers
Tim.


"Tim Childs" wrote in message
...