I set my Excel application to work today connected live with IB.
Several times it gave me errors. I am not sure why?
Application.Goto Reference:="Name" Gives errors sometimes
Where "Name" is a defined name in my work book.
The goto works fine when called via macro. HOwever sometimes when my
code is running it gives an object undefined error.
I am running this macro every 2 seconds. Also I am using ActiveX my
VB code is event driven so its possible that 2 events coincide.
I just don't understand why it works some of the time and not others?
Regards
Chas
