PDA

View Full Version : Excel Problem


giu76cala
07-05-2006, 08:09 AM
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
07-05-2006, 08:30 AM
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
07-05-2006, 08:41 AM
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
07-05-2006, 08:49 AM
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.