none
Excel 2016 validation.add and exception RRS feed

  • Question

  • Hello,

    a customer gets a Exception from HRESULT: 0x800A03EC at

    Microsoft.Office.Interop.Excel.Validation.Add using Excel 2016.

    The code Looks like (simplified)

    using Excel = Microsoft.Office.Interop.Excel;
    
    Excel.Range er
    // set er
    ...
    Excel.Validation val = er.Validation;
    val.Delete();
    val.Add(Type: Excel.XlDVType.xlValidateCustom, Formula1: true);
    

    This does work until Excel 2013.

    Why doesn't it work with Excel 2016 anymore ?

    TIA

      Hendrik Schmieder

    Tuesday, April 26, 2016 12:29 PM

All replies