Microsoft Excel - Save As CSV (Macro)
This is a macro which will help you to save a worksheet to CSV (Comma-Separated Values) using a shortcut key. The trick is to execute a customized macro named "SaveAsCSV". You may further modify this macro to work for other format. Discussion below will be focused on using CSV format. How does it work? Save active excel file. Get file name for active excel file. Get current sheet name. Check if sheet name contains desired extension (.csv) Append file extension if required. Save current sheet as desired format (CSV). Close current CSV File. Reload active excel file.