I don't think it is good idea. Excel will be many times SLOWER than AFL. And of course any script .RUN waits until completion.
Best regards, Tomasz Janeczko amibroker.com ----- Original Message ----- From: "sonyfanaticsss" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, August 26, 2008 5:48 AM Subject: [amibroker] Re: Hitting the AFL execution limit? > Hello, > > To solve the problem mentioned in the post below, I've ported the code > to Excel. A AFL formula is used to open Excel and run the macro (with > vbscript). > > But now I have a new problem. Amibroker seems to halt until the macro > finished its calculation. And if the macro takes too long to finish, > Amibroker will popup a dialog box asking me to either "switch to" that > application, or "Retry". > > I think the problem is in the OLE vbscript, because the > Excel.Application.Run("some macro") method do not return until the > macro is finished. > > I wonder if anyone can help? > > Thank you. > > > > --- In [email protected], "sonyfanaticsss" > <[EMAIL PROTECTED]> wrote: >> >> Hi, >> >> I've 6 formulas running in my active window now, and when I scroll the >> chart with my mouse button there is a very noticeable lag in the >> redraw speed. The top chart draws first and the bottom chart last. I >> think it takes almost one second for the bottom chart to update with >> new plots and values. >> >> I wonder if I have hit the AFL execution limit, or is this just normal >> phenomenon? >> >> Thank you very much for your help. >> > > > > ------------------------------------ > > Please note that this group is for discussion between users only. > > To get support from AmiBroker please send an e-mail directly to > SUPPORT {at} amibroker.com > > For NEW RELEASE ANNOUNCEMENTS and other news always check DEVLOG: > http://www.amibroker.com/devlog/ > > For other support material please check also: > http://www.amibroker.com/support.html > Yahoo! Groups Links > > >
