We can use VBA to convert and Save the Excel File as CSV file. This example macro will help us to know how to convert Excel Worksheet into a CSV Comma delimited text file. This can be used in Excel 2003,2007,2010,2013.

vba code to convert excel to csv- Syntax

Here is the example Excel VBA Syntax to convert the Excel to CSV.

Workbook.SaveAs fileName:="filepath to save the csv file", FileFormat:=xlCSV, CreateBackup:=False

VBA code to Convert and Save the Excel to CSV – Example

Here is the example macro to convert the Excel worksheet to CSV file.

'vba code to convert excel to csv
Sub vba_code_to_convert_excel_to_csv()
Set wb = Workbooks.Open("C:\temp\testwb.xlsx")
wb.SaveAs fileName:="C:\temp\testC.csv", FileFormat:=xlCSV, CreateBackup:=False
End Sub

This macro will open an existing Excel workbook from the C drive and Convert the file into CSV and Save the file with .CSV extension in the specified Folder. We are using Workbook Open method to open a file. SaveAs method to Save the file into destination folder. This example will be help full, if you wan to convert all excel files in a directory into CSV file.

VBA code to Convert and Save the Excel to CSV – Instructions

Please follow the below step by step instructions to test this Example VBA Macro codes:

  • 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
  • Step 4: Copy the above code and paste in the code module which have inserted in the above step
  • Step 5: Change the Workbook name in the code as per your example folder and also change the destination file path as per your requirement
  • Step 6: Now press F5 to execute the code or F8 to debug the Macro to check it

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!