开云体育

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

IB claims that activeX should not be used with excel spreadsheets.
They recommend the DDE interface. Search for info on IB's site.

Andy M.

--- In twsapi@y..., "Chas_watkins" <chas@o...> wrote:

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

Try using this:

Application.Goto ThisWorkbook.Names("Name").RefersToRange

where "Name" is your rangename in quotes.