I am writing a
VB.NET plugin for Excel. I want to call the
ApplicationObject.Ontime function to call another function after a specified
time.
AppObj.OnTime Now + TimeSerial(0, 0, 5), "MyCustom SubName"
I tried putting the calling and called function in the same class but it
throws an error. "Exception from HRESULT: 0x800A03EC."
I also tried putting the called function in a Global Module but no success..
still the same exception.
This thing works in a Macro( wherein i specify ThisworkBooK.<CALLED FUNCTION
Name)
Does the Ontime Function work in an application or just that it works in a
Macro?
If it does, what is the right way to call it?
thanks for your suggestions.
-Satin