Question: how to convert csv file to excel in vba?
Answer: VBA Code – Convert CSV to Excel Create a new workbook and copy the file to a new Module, change the desired folder path highlighted in blue. Basically what the Macro does is to open csv in Excel and then save as xlsx (xlOpenXMLWorkbook) under specified folder.