How to Open XML Files in Excel Using VBA Code ?

Talk to you soon.

Prove you're human: Type the code shown.

By clicking any of the above buttons, I agree to the terms & conditions and privacy policy, and I consent to receive updates via SMS or email

+1 650 491 3131

Power BI Reporting:
Beginner to Expert
Power BI | Power Pivot | Power Query | DAX
Microsoft Excel Reporting:
Business Reporting & Model Building
60+ Formulas | Data Stories | Advanced Reporting & Modeling
Excel VBA Programming
for Automation
VB Programming | Report Automation |
MS-Office Automation

Business Professionals

Techno-Business Professionals

Technology Professionals

Programs & Courses

New

Home

About Us

Programs & Courses

New

Home | About Us | Contact Us

+1 650 491 3131

inquiry@excelgoodies.com

ExcelGoodies WorldwideUSA | UK | Australia | Singapore | Phillipinnes

Open XML File in Excel

Here are the primitive commands to open an XML file in Microsoft Excel.

My whole point stands on one belief –

You learn best when “you connect what you learn with something you know”.

Before I say VBA Excel could be a good start, let me emphasize few things –

Undeniable Fact: Being a business user, Excel (or any spreadsheet for that matter) is our “go-to” tool for any reporting.

So, how does learning VBA become easy for business users?

Code is written inside the Excel

Sub Open_XMLFile()
Dim OXML As Workbook
Set OXML = Workbooks.OpenXML(“c:\sample.xml”)
End Sub
Sub Open_XML_File_As_List()
Dim OXML As Workbook
Set OXML = Workbooks.OpenXML(Filename:=”c:
\sample.xml”,
LoadOption:=XlXmlLoadOption.xlXmlLoadImportToList)

This option will work for Excel 2003 and above

Explore comprehensive Excel VBA Macro Programming here and, learn to automate your routine Excel Reports, Processes and Tasks.

Happy Excelling
Team Excelgoodies

VBA & Python

Don't forgot to share this post!

New

Next Batches Now Live

Power BI