Excel Goodies Logo
+91 9176633248
+91 9176633248
+91 9176633248

Courses

New

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

New

Next Batches Now Live

Power BIPower BI
Power BISQL
Power BIPower Apps
Power BIPower Automate
Power BIMicrosoft Fabrics
Power BIAzure Data Engineering
Explore Dates & Reserve Your Spot → Reserve Your Spot →

Related Articles