Excel.Workbooks.Open behaviors differently in VBA and VB
 

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?

Excel.Workbooks.Open behaviors differently in VBA and VB
 

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?