Recorded VBA Text to Columns performs differently

[Harsh210]

Hi All,
I recorded the following macro:

Sub TtoC()
'
' TtoC Macro
'

'
    Columns("Q:Q").Select
    Application.CutCopyMode = False
    Selection.TextToColumns Destination:=Range("Q1"), DataType:=xlDelimited, _
        TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
        Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
        :=Array(1, 4), TrailingMinusNumbers:=False
      
End Sub

Upon running the recorded macro on a copy of the raw data, I get a different output.

The result of the action was as follows:

Accounting Period - Raw data	Accounting Period - After Manual Text to Columns	Accounting Period - After VBA Text to Columns
Feb-22	1/02/2022	22/02/2022

 

[airforceone]

Did you already check your unit's region and/or language settings? It might help.
If the problem still persist would you be kind enough to at least give us a sample of your data in xl2bb so that other online member can see the problem and eventually help you...

 

[HeadAgainstABrickWall]

VBA seems to work differently in macro vs manual. It appears that in the manual function, it's recognising your data as "mmm-yy", while the USA-centric VBA is seeing it as "mmm-dd". Which is correct?