Hi,
I have set up a macro that copies all of a WORD document containing a table of data to EXCEL and have been having a problem copying dates that I was hoping someone could help with.
The routine that works correctly when carrying out the process manually is to copy all of the WORD document to the clipboard and then paste this as text using Paste Special in EXCEL.
The problem when programming VBA to do this is that the dates are not copied correctly. Examples of the problems being as follows:
01/10/08 (i.e. 1 October 2008) converted to 10/01/08
16/10/08 (i.e. 16 October 2008) coverted to string "16/10/08" not a value
I realise this is something to do with the dates copied being treated as US dates (i.e. mm/dd/yy) instead of UK dates (dd/mm/yy) but can't understand why the copy routine works manually and not in VBA ?
Is there a line that can be added to VBA to stop this problem ?
Thanks for any advice.
Goggs75