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

G

giantdino

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
 
G

giantdino

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top