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.