Question: how to export excel sheet to csv vba?
Answer: Copy the Range from your Excel Sheet – rngToSave. Create a new Excel Workbook. Paste the Copied range data in to the first sheet of the workbook from A1 cell – .Sheets(1).Range(“A1”).PasteSpecial xlPasteValues. SaveAs this new workbook as CSV file. You are done Now.