Amibroker Automation

[daya]

Dear All,

Actually,I want to automate Amibroker analysis part.Amibroker is stock trading software.(Hope this is not a restricated).

OK.

I started experimanting with Excel.

I write as:

#include <Constants.au3>

Local $MyExcel = ObjCreate("Excel.Application")

If @error Then
 MsgBox($MB_SYSTEMMODAL, "ExcelTest", "Error creating the Excel Object. Error code: " & @error)

 Exit

EndIf

If Not IsObj($MyExcel) Then
 MsgBox($MB_SYSTEMMODAL, "ExcelTest", "I'm sorry, but creation of the Excel object failed.")

 Exit

EndIf

$MyExcel.Visible = 1

upto now Excel is not visible but when I add following line only then Excel is visible. Why? where i am getting wrong?

$MyExcel.workbooks.add

 

Regards

[JLogan3o13]

Why not do this instead?

#include <Excel.au3>
 
Local $oExcel = _ExcelBookNew()