Question: how to convert csv file to excel file in vba?
Answer: Enable a new workbook, press Alt + F11 keys to open Microsoft Visual Basic for Applications window, and click Insert > Module. In the popping out dialog, select the specified folder containing the CSV files you want to convert. ...  Click OK, all the CSV files in the selected folder have been converted to XLS files in it.