Jimbo Razza
Board Regular
- Joined
- May 21, 2005
- Messages
- 114
Hi There
I have recorded a macro that imports data and splits the data using the text import function set at fixed width.
One of the resulting columns of data is a date.
When I run the macro, any dates from the 1st to the 12th of any month get messed up.
I.e. 01/12/2007 becomes 12/01/2007.
It only does it on dates that range from the 1st to the 12th and all other dates come out fine.
It only does it when I run the macro. When I'm recording the macro or if I do the steps manually, all dates are fine.
I have recorded a macro that imports data and splits the data using the text import function set at fixed width.
One of the resulting columns of data is a date.
When I run the macro, any dates from the 1st to the 12th of any month get messed up.
I.e. 01/12/2007 becomes 12/01/2007.
It only does it on dates that range from the 1st to the 12th and all other dates come out fine.
It only does it when I run the macro. When I'm recording the macro or if I do the steps manually, all dates are fine.
