xlAbort equivalent for XLL functions in vb.net with ADX?

Add-in Express™ Support Service
That's what is more important than anything else

xlAbort equivalent for XLL functions in vb.net with ADX?
enable Excel user to abort long-running XLL function calculations 
Heiko Sunev




Posts: 13
Joined: 2008-11-30
Is there a way to abort a hanging or long-running XLL function?
Either after a pre-defined time has elapsed (say 10,000ms) or after the impatient Excel user hits the <ESC> key in his Excel frontend?

The C API offers xlAbort (Microsoft classifies it as not thread-safe, though). Does ADX offer a similar handle for vb2005/2008 developers to pull the brake on a long-running XLL calculation?

thx
H
Posted 30 Nov, 2008 10:51:03 Top
Eugene Astafiev


Add-in Express team


Posts: 8540
Joined: 2007-07-25
Hello Heiko,

Sure. Add-in Express doesn't limit programmers.

You can use the CallWorksheetFunction function of the Module static property with the AddinExpress.MSO.ADXExcelWorkseetFunction.Abort parameter.
.NET, Extended MAPI, Windows Phone & RT
Posted 01 Dec, 2008 09:06:09 Top