VBA code to convert excel to xml

Home/VBA/VBA code to convert excel to xml

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



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 XML- Syntax

Here is the example Excel VBA Syntax to convert the Excel to XML format.

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

VBA code to Convert and Save the Excel to XML- Example

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

'vba code to convert excel to xml
Sub vba_code_to_convert_excel_to_xml()
Set wb = Workbooks.Open("C:\temp\testwb.xlsx")
wb.SaveAs fileName:="C:\temp\testX.xml", FileFormat:= _
xlXMLSpreadsheet, ReadOnlyRecommended:=False, CreateBackup:=False
End Sub

This macro will open an existing Excel workbook from the C drive and Convert the file into XML and Save the file with .xml 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 XML (xlXMLSpreadsheet format) file.

VBA code to Convert and Save the Excel to XML- 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 the macro
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

null value vbamsgbox vba examplevba find duplicatesunlock protected sheet excellearn excel vbavba open xls filesum if in sqlvba combobox additemsql tutorial advanced with examplesswot templates for wordvba project examplesexcel formula codesmerge columns in excel 2007vba commentingmicrosoft excel macrosvba autofithlookup excel 2010access vba sql queryexcel 2007 pivot table tutorialexcel transfer data to another sheetexcel adoddl commandsmacro to delete duplicate rowsmacro delete rowexcel userform examplesexcel vba displayexcel vba loop through rangedashboard formats in excelupdate sql server from excelrun macro on open excelexcel vba programming tutorialhow do i get rid of duplicates in excelwhat is a pivot chart in excelexcel unprotect all sheetsvba macro wordexcel tips for beginnershow to unhide all hidden columns in excelexcel mergecellsexcel graph formattingexcel vba waitvertical lookup excel 2007unhide lines in excelms access vba codeexcel macro to remove duplicatesvba vbnewlinemerging excel cellshow to protect workbook in excelaverageifs excelexcel vba vbcrlfsort macro excelexcel vba close workbookmacro workbookexcel vba matchvba call subvba multiple if statementsexcel dashboard samplesunlock excel filesvba iconrca templatevba userforms addpowerpivot excel 2010 examplesformat cells vbauser input in vbaexcel vba delete columnscheckbox tutorialwhat does vba stand fordml and ddl querieslearn vba for accessvba excel graphswot analysis templates powerpointhow to unprotect excel sheetexcel automatic row heightexcel vba copy and pasteiferror excel functionlen function excelhow to delete rows on excelview developer tab in excelexcel 2007 pivot charthow do you delete cells in excelproject costing templatemerging rows in excelcombobox additemremove duplicate entries in excelhow to sort data in excel 2007tutorial vba excel