View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Satin Satin is offline
external usenet poster
 
Posts: 5
Default OnTime Function Call

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