save scv file as xlsx

[Tody03]

I want to write a macro that will save the current filename.csv file as filename.xlsx
How to do it?

 

[Legacy 421546]

I want to write a macro that will save the current filename.csv file as filename.xlsx
How to do it?

Excel files containg macros must have an extension .xlsm to work properly.

 

[Legacy 421546]

Sorry Tody03, read your post too quickly.
Try google VBA SaveAs. One answer:
https://www.rondebruin.nl/win/s5/win001.htm

 

[Tody03]

thanks for the quick response. i will study it.

 

[Tody03]

I am lost, I do not know VBA and can not implement the information to my needs.
Below is my macro, How can I change it that every csv file that I open will be save in the same name with xlsx ending.

Sub csv_xlsx() ActiveWorkbook.SaveAs filename:= _
"C:\Users\Tody\Desktop\b-tests\booking-jerusalem_general-2018-01-27-00-50-t437.xlsx" _
, FileFormat:=xlOpenXMLWorkbook, CreateBackup:=False
End Sub