Excel.Workbooks.Open behaviors differently in VBA and VB

G

Guest

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?
 
G

Guest

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

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

Similar Threads

VBA Excel.WorkBooks.Open can't open an XML format xls file 2
Possible error in VBA Workbooks.Open method for xlsx file 0
VB Error in spreadsheet with no VBA code 2
Protecting a VBA project 3
Treeview - XML editor in VBA 0
Open an Excel file located in a web page - How to open it 0
Convert image to Base64 string in VBA 3
Convert from vba to vb? 8

Top