Please ignore this issue. I found that in VB I am using .xls. Changing it to
..xlsx will solve the problem.


"giantdino" wrote:

I have a xml based excel file (.xlsx). In VBA editor inside excel, if I put
Workgbooks.Open "abc.xlsx", it will load the file correctly in spreadsheet
format. However, in a standalone vb application, if I put the same statement,
Excel will open the file in text format.
Any idea why this is happening and how to fix it?