Excel Problem

[giu76cala]

I developed a trading system in VBA for Excel.

In the VB Code I added in the refererences menĂ¹ NinjaTrader Client. After I wrote the code:

Dim myClient As NinjaTrader_Client.Client


ORDINE = 2

Set myClient = New NinjaTrader_Client.Client

ORDINE = myClient.Command("CANCELALLORDERS", "", "", "", 0, "", 0, 0, "", "", "", "", "")


but he give an error occured. It isn't able to create the ActiveX object.



Can you help me?



tks

[NinjaTrader_Dierk]

imported post

a) Please double check that you proceeded as documented in the releveant section of the help guide.
b) What is the exact error you get?
c) When do you get this error? On adding the project reference or on running the project?
d) What operations system are you on?

[giu76cala]

imported post

a) Done

b)run time 429 don't create the activix object

c)on running the project at Set myClient = New NinjaTrader_Client.Client

d)Microsoft XP professional 2002 SP2

[NinjaTrader_Dierk]

imported post

Hmm ... I'm on a loss. The only thing I know is that COM is sensitive to setup issues. So an uninstall and reinstall of NT via the control panel "could" make a difference.