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

frequently asked sql queries in interviews with answersdatabase dmldelete a row vbafilesystemobject opentextfileconstruction cost estimator excelvba unhide columnsexcel vba inputboxvba class module tutorialexcel vba cells offsetconstruction project template excelvba chrrun vba codemicrosoft excel multiple if statementsexcel macro referencehow to find duplicates in excel 2007excel 2007 password protect workbookcombine worksheets into one worksheetvba worksheetexcel 2007 pivot table tutorialexcel insert tick boxvlookup function in ms excelvba excel advanced tutorialunprotect sheetcapacity planning spreadsheet excelunhide all in excelexcel meeting minutes templateproject management plan excel templatevba macro for looplearn excel macros step by stepvba istextvba connection string sql servervba create macroclearcontents vbavb file handlingexcel macro active worksheetexcel lookup vectorend xlupexcel vba copy range to another worksheethow can use pivot table in excelvba wordexcel saveas fileformatexcel copy cellsexcel project planner templatevlookup col_index_numhow to apply sumif formula in exceldeclaring public variables in vbaexcel macro open worksheetunprotect excel sheet with passworddelete empty cells excelhow to use advanced filter in excelvlookup macro in excelcomment in excel vbaactivate developer tab in excelexample vbaestimation template excelpivot table tutorial excel 2013range variable vbaexcel countif exampleuseful excel sheetscell format vbabubble graphs excelexcel column width in inchescreate an array vbacontrols vbaexcel macro merge cellsmacro dialog boxvba byrefprogramming excel vbaexcel vba array of stringsexcel macro passwordcombine cells in excel 2007cell in vbaproject status dashboard pptdelete empty cells in excelmacros tutorialsexport excel macroexecutive dashboard excelcommand button in excel 2007vba vbnewlinewhat is an array in vbatechnical aptitude test questions and answersadvanced filter excel unique recordsproject dashboard templates