Using office 2003. Attempting to copy a range of cells from one file (closed) to an other file. Works ok but the dates (if under 12..) are re-formated into the American format i.e. copy 06/01/2006, paste 01/06/2006. Looks like if over 12. Excel logic prevails so dates stay on the same format. This does not happen if this is done manually, only happens when using VB. Has anyone come accross this?
The code I use is:
GETValuesFromClosedWorkbook "C:", ("D4"), "Sunbatch", "A1:R3000"
Columns("T:T").Select
However, even a simple copy / paste instruction via VB seems to give same wrong outcome.
This is driving me nuts.
If you can, please-please help.
Many thanks,
The code I use is:
GETValuesFromClosedWorkbook "C:", ("D4"), "Sunbatch", "A1:R3000"
Columns("T:T").Select
However, even a simple copy / paste instruction via VB seems to give same wrong outcome.
This is driving me nuts.
If you can, please-please help.
Many thanks,