Unwanted date conversion when opening a workbook
I have a document, saved as text from another application (business objects) which contains the value 01/06/2004 (1st June 2004) in cell A5
When I open the workbook mannually I see the correct date, but when I open it with code (workbooks.open("path.xls")) it comes up with 01/06/200
Any help
Thank
Rob
|