I have a windows application and using Microsoft.Office.Interop.Excel.dll, v14.0.0.0 to do Excel related operations.
My system has Office 2007. While executing VLOOKUP with conditional operator and or Saving excel file I am getting common error:
System.Runtime.InteropServices.COMException occurred
HResult=-2146827284
Message=Exception from HRESULT: 0x800A03EC
The same works well where I have office 2013. Issue is even with 2010.
What is the best solution for this type of exceptions? I need to support office 2007 and above.