public ExternalCommandResult Execute(Application excelApp, ref string errorMessage, ref Range errorRange)
{
DllActivator_eZx dat = new DllActivator_eZx();
dat.ActivateReferences();
try
{
DoSomething(excelApp);
return(ExternalCommandResult.Succeeded);
}
catch (Exception ex)
{
errorMessage = ex.Message + "\r\n\r\n" + ex.StackTrace;
return(ExternalCommandResult.Failed);
}
}
/// <summary>
/// 用于 AddinManager 对代码进行调试
/// </summary>
/// <param name="cmd"></param>
/// <param name="excelApp"></param>
/// <param name="errorMessage"></param>
/// <param name="errorRange"></param>
/// <returns></returns>
public static ExternalCommandResult DebugInAddinManager(ExternalCommand cmd, Application excelApp,
ref string errorMessage, ref Range errorRange)
{
DllActivator_eZx dat = new DllActivator_eZx();
dat.ActivateReferences();
try
{
var res = cmd(excelApp);
switch (res)
{
}
return(res);
}
catch (Exception ex)
{
errorMessage = ex.Message + "\r\n\r\n" + ex.StackTrace;
return(ExternalCommandResult.Failed);
}
finally
{
excelApp.ScreenUpdating = true;
}
}
