VBA code to convert excel to csv

Home/VBA/VBA code to convert excel to csv

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.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


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


Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |January 20th, 2015|VBA|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment


Related pages


excel vba connect to access databasevba open fileunlock excel worksheetcheck for duplicates excelexcel activesheethow to expand row height in excellookup excelqlikview vbscript tutorialdashboard template powerpointcalculate weeks between two dates excelfree download gantt chart excelvba columns countdatabase interview questions for fresherscheckbox syntaxvlookup excel 2010 step by stepaccess vba close reportconcatenate formula excelhow do you hide a column in excellock a spreadsheetinsert row on excelcase excel vbaprotected workbook forgot passwordsample excel dashboardexcel logical operatorexcel visual basic tutorial for beginnerssimple vba code for excelmicrosoft excel vlookup examplesexcel vba additemexcel how to insert rowformat column vbaexcel macro selectionmerge cells excelexcel iteration exampleuser defined functions in vbaexcel ribbon vbahow to set macro security in excel 2010excel macro programmingsql server macrovbscript message boxsample dashboard in excelformula of countif in excelmacros function in excelexcel labelingvba odbcvlookup between two valueslookup formula in excel 2007excel vba transfer data from one workbook to anotherdelete rows in vbahow do you check for duplicates in excelbasic vba commandscheckbox macrounlock password protected excel sheetexcel vba application.getsaveasfilenameexcel chart macromacro ms exceldo until loop vba example3d bubble chart excelbcg interview processarray length in vbavba getrowsvba for excel pdfhow to add a blank row in excelvba change font sizeexcell if statementsexcel vba tutorialsarray length in vbaexcel vba activeworkbook saveasfree excel 2013 add inssample vbscript programsexcel construction estimating templateaccess parameter query vbavba array tutorialhighlight duplicates excel 2010excel vba select a rangecommand button vba excelexcel test for empty cellshort key for insert row in excelsubroutine vbavba excel copy rangehow to change row height in excelmod row excel