Excelgoodies logo +44 (0)20 3769 3689
+44 (0)20 3769 3689  

 Business Professionals

 Techno-Business Professionals

 Technology Professionals

 Business Professionals

 Techno-Business Professionals

 Technology Professionals

Home

|

About Us

|

Contact Us

Programs & Courses

New

Home | About Us | Contact Us

+44 (0)20 3769 3689

support@excelgoodies.uk

ExcelGoodies Worldwide United States | Canada | Singapore

LEARN THIS HANDS ON

Excel VBA Programming

GMT . Live Online FILLING FAST
View all upcoming batches
Open XML File in Excel

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
SQLSQL
Power AppsPower Apps
Power AutomatePower Automate
Microsoft FabricMicrosoft Fabrics
AzureAzure Data Engineering
Explore Dates & Reserve Your Spot → Reserve Your Spot →

Related Articles