Macro not recording moving from 1 workbook to another

1
I am wanting to clear the contents of a .csv file, move to a .xlsm workbook to sort data prior to copy/ paste special (values + transpose) onto the blank .csv.

After recording spreadsheet on running it, it stops because it hasn't recorded the move from the .csv to the .xslm. VBA below. This only became a problem after upgrading from Mac MS Office/Excel 2011 to 2021.

Is there something wrong with my application or am I missing something?

VBA:
Sub Macro1()
'
' Macro1 Macro
'

'
Workbooks.OpenText FileName:= _
"/Users/stephen/Documents/Publications/2023 t_delay/delay.csv", Origin:=65001 _
, StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=True, Semicolon:=False, Comma:=True, _
Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), Array( _
3, 1), Array(4, 1), Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1), Array(10 _
, 1), Array(11, 1), Array(12, 1), Array(13, 1), Array(14, 1), Array(15, 1), Array(16, 1), _
Array(17, 1), Array(18, 1), Array(19, 1), Array(20, 1)), TrailingMinusNumbers:=True
Cells.Select
Selection.ClearContents
Range("A1").Select

[[Here the macro should have recorded moving from .csv to .xslm. It therefore stalls at the next line because it can't find the named sheet]]

Sheets("Var lists").Select
Columns("G:G").Select

Originally Posted by tays01s

I am wanting to clear the contents of a .csv file, move to a .xlsm workbook to sort data prior to copy/ paste special (values + transpose) onto the blank .csv.

Not need to clear a csv text file, very useless ! Just overwrite it via SaveAs …

I've previously found it useful to ensure no old data remain.

However, that wasn't the problem. It's Excel's failure to record moving from 1 workbook to another.

Moving ? As it is useless just restart with the Macro Recorder only from the data workbook
in order to directly save - overwrite - the csv text file …
For more help if necessary attach the source data workbook and the exact expected result csv text file with your best elaboration.