Text To Columns vba producing different results on differents pc

[baloobb]

Hi all,

I have a problem, I set up a macro to format a column (fixed-width) with a date format DMY. It works fine on my PC but on a colleague's pc, it isn't working.

Here the code

Columns("A:A").Select
Selection.TextToColumns Destination:=Range("A1"), DataType:=xlFixedWidth, _
FieldInfo:=Array(0, 4), TrailingMinusNumbers:=True

Row data are formatted as general.

Planned_Start_Date

17/01/2021

11/01/2021

11/03/2021

14/04/2021

Why only on my pc the code works fine? Am I missing something?

Thanks to whom can help my to sort it out

 

[Joe4]

Welcome to the Board!

What exactly do you mean by it isn't working on your colleague's PC?
Are you getting errors? If so, what?
Or are you getting unexpected results? If so, what?

Also answer the following questions:
1. Are you both trying it on the EXACT same file?
2. Are Macros/VBA enabled on the other computer?
3. Are you both using the same version of Excel?
4. Do you both have the same regional settings?

 

[baloobb]

Thank you to have me on board!

Sorry, I forgot to mention, the same scenario, the only thing that is different is the pc.

1. Are you both trying it on the EXACT same file? YES
2. Are Macros/VBA enabled on the other computer? YES
3. Are you both using the same version of Excel? YES
4. Do you both have the same regional settings? need to check, this could be the problem

What I got is the date in the right way, dd/mm/yyyy while he gets the data in the wrong format mm/dd/yyyy

thank you

 

[Joe4]

What I got is the date in the right way, dd/mm/yyyy while he gets the data in the wrong format mm/dd/yyyy

That seems to suggest that there are different regional settings on each computer.
Look at how to set the regional date settings section in this link: Excel Tips: Understanding Regional Differences in Excel

 

[baloobb]

Hi Joe4 thank you the error was in the regional settings!

 

[Joe4]

You are welcome.