When I use VBA to copy a string from another application
(basiscally this is a screen scrape) if the string is in
the format 12/04/04 (dd/mm/yy) this is entered into a
spreadshett as 04/12/04. 13/04/04 would be unaffected as
either excel or XP knows that 04/13/04 is not a valid
date. I've tried using Cdate and then allocating the
variable the correct format (A=format(b,"dd/mm/yy"))
formating the cell (numberformat ="dd/mm/yy") but it
still does it! I also thought of using Cstr but VBA
interprets the string as a date so that won't work. I've
set my short date format on the machine to match,but no
good. Is my only solution SP3?