Does setting Data Validation work with Excel actxserver

2 ビュー (過去 30 日間)

Dave Watson 2015 年 10 月 19 日

0
リンク

この質問への直接リンク

https://jp.mathworks.com/matlabcentral/answers/249497-does-setting-data-validation-work-with-excel-actxserver

編集済み: Dave Watson 2015 年 10 月 19 日

Has anyone got this to work from a program? I have tried the statement below in a program (100% failure), from the command line (~90% success), and in the debugger (~50% success). I have tried putting a .Delete call in first and have tried a .Modify call instead of the .Add?

Thanks.

hs is a Range object; ProType is a defined name in the workbook (which is workbook scope) and is defined as a range on a sheet. K>> hs.Range(dRange).Validation.Add(3, 1, 1, '=ProType') Error using Interface.Microsoft_Excel_14.0_Object_Library.Validation/Add Error: Object returned error code: 0x800A03EC