This is driving me nuts... Dates deformated

[Eshton]

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,

 

[Dufus]

Eshton,

Check the destination cells for the correct formatting first. If they are general, change them to Date of some kind. Next, use Paste Special Values in your macro so you don't pick up any formatting from the source cells. Does this solve the problem?

If not, try creating a dummy workbook from scratch and populate it with dates. Create another dummy workbook from scratch and use it as the destination workbook. Does the problem still occur?

Dufus

 

[Eshton]

Thanks Dufus for the prompt reply.

Have tried your suggestion (amongst many things I have tried) but I'm getting the same result. It does'nt make sense. Will appreciate any other ideas.

Many thanks,
Eshton

 

[Dufus]

This is the kind of thing it's really difficult to decipher without having a copy of the suspect workbook. I'm out of ideas for the time being though.

Dufus