Question: how to convert xls to csv using macro?
Answer: Step 1: Open a New Excel workbook.
Step 2: Press Alt+F11 – This will open the VBA Editor (alternatively, you can open it from Developer Tab in Excel Ribbon)
Step 3: Insert a code module from then insert menu of the VBE.