Using Excel to Open XML file like XML List

[wayliff]

I am attempting to open an XML file like an XML List using excel, i'm getting an unhandled null reference exception when it attempts to run the last command...not sure what to make of it.

Can anybody shine the light here? I'm new to vb.net development and going through my learning steps...

Here's the code i'm using...

Dim oXL As New Microsoft.Office.Interop.Excel.Application
Dim oWB As Microsoft.Office.Interop.Excel.Workbook
Dim oSheet As New Microsoft.Office.Interop.Excel.Worksheet
Dim xlXmlLoadOption1 As Microsoft.Office.Interop.Excel.XlXmlLoadOption
 
 
oXL = CreateObject("Excel.Application")
oXL.Visible = False
oXL.Workbooks.OpenXML(selectfiledlg.FileName.ToString, , xlXmlLoadOption1)

 

[JohnH]

Looks like there have to be set a value for XlXmlLoadOption.
http://msdn2.microsoft.com/en-us/library/aa195815(office.11).aspx