daya Posted December 31, 2013 Share Posted December 31, 2013 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 Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted January 4, 2014 Moderators Share Posted January 4, 2014 Why not do this instead? #include <Excel.au3> Local $oExcel = _ExcelBookNew() "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now