VBA Excel.WorkBooks.Open can't open an XML format xls file

[Guest]

I have an application output excel file in the new xml format. If I open the
xml file in excel, it shows correctly a spreadsheet. However, if I use VBA
Excel.WorkBooks.Open to load this file, excel will give me a text based xml
content.
Is there a way for me to open this xml file in spreadsheet format in Excel?
thanks

 

[gimme_this_gimme_that]

I'm using XL 2003 SP2.

This works for me:

Data->XML->Import

 

[Guest]

Thanks for your reply. However, is there any way to open a workbook in VBA
command?