Thread: Excel.Workbooks.Open behaviors differently in VBA and VB
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
giantdino giantdino is offline
external usenet poster
  
Posts: 4
Default 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?

Reply With QuoteReply With Quote