CongTin Posted April 17, 2010 Share Posted April 17, 2010 Dear all,I am a Newbie,Please support me in this issue.My problem is:I have a Excel file with this formula: =IF(LEFT(B2,1)="1",RIGHT(B2,6)&"/"&RIGHT(B4,19),"")I type this formula to Excel directly, it can work excactly.I would like to use AutoIT to put this formula to my Excel file but I cannot write the correct code.I have tried with:1./ _ExcelWriteCell($nmc,"=IF(LEFT(B2,1)="1",RIGHT(B2,6)&"/"&RIGHT(B4,19),"")","C2") (ERROR: syntax error)2./ _ExcelWriteCell($nmc,"=IF(LEFT(B2,1)=""1"",RIGHT(B2,6)&""/""&RIGHT(B4,19),"")","C2") (Cannot work)3./ _ExcelWriteFormula($nmc,"=IF(LEFT(B2,1)="1",RIGHT(B2,6)&"/"&RIGHT(B4,19),"")","C2") (ERROR: syntax error)4./ _ExcelWriteFormula($nmc,"=IF(LEFT(B2,1)=""1"",RIGHT(B2,6)&""/""&RIGHT(B4,19),"")","C2") (Cannot work)Please support me to figure out this one. Thanks for your time,Regards, Link to comment Share on other sites More sharing options...
l3ill Posted April 17, 2010 Share Posted April 17, 2010 Hi Congtin & Welcome,your quotes seem to be causing the syntax error...besides that I tested your formula in 2007 and it is also giving me an error.So, 2 problems:have another look at your formulause single quotes in your formulaexample:_ExcelWriteFormula($oExcel, "=IF(LEFT(B2,1)='1',RIGHT(B2,6)&'/'&RIGHT(B4,19),"")", 1, 2) My Contributions... SnippetBrowser NewSciTE PathFinder Text File Manipulation FTP Connection Tester / INI File - Read, Write, Save & Load Example Link to comment Share on other sites More sharing options...
picaxe Posted April 17, 2010 Share Posted April 17, 2010 This works on Excel2003 #include <Excel.au3> Local $oExcel = _ExcelBookNew() ;Create new book, make it visible _ExcelWriteCell($oExcel, 1234567, 2, 2) ; B2 _ExcelWriteCell($oExcel, 234567, 4, 2) ; B4 _ExcelWriteFormula($oExcel, '=IF(LEFT(R2C2,1)="1",RIGHT(R2C2,6)/RIGHT(R4C2,19),"")', 2, 3) ; C2 Link to comment Share on other sites More sharing options...
CongTin Posted April 18, 2010 Author Share Posted April 18, 2010 Hi Congtin & Welcome, your quotes seem to be causing the syntax error...besides that I tested your formula in 2007 and it is also giving me an error. So, 2 problems: have another look at your formulause single quotes in your formulaexample: _ExcelWriteFormula($oExcel, "=IF(LEFT(B2,1)='1',RIGHT(B2,6)&'/'&RIGHT(B4,19),"")", 1, 2) Hi Billo, Thank you very much for your support. Yes, I am using office 2007. I will test it according to your advice with sigle quotes and inform you the result if it is ok. Thank you again, Warm regards, Link to comment Share on other sites More sharing options...
CongTin Posted April 18, 2010 Author Share Posted April 18, 2010 This works on Excel2003 #include <Excel.au3> Local $oExcel = _ExcelBookNew() ;Create new book, make it visible _ExcelWriteCell($oExcel, 1234567, 2, 2) ; B2 _ExcelWriteCell($oExcel, 234567, 4, 2) ; B4 _ExcelWriteFormula($oExcel, '=IF(LEFT(R2C2,1)="1",RIGHT(R2C2,6)/RIGHT(R4C2,19),"")', 2, 3) ; C2 Dear Picaxe, Thanks for your information. My office is 2007 and maybe this is the reason of problem. I will try testing with Excel 2003. Hope to continuously received your support in next time, Warm regards, Link to comment Share on other sites More sharing options...
CongTin Posted April 19, 2010 Author Share Posted April 19, 2010 Hi Billo,Thank you very much for your support. Yes, I am using office 2007.I will test it according to your advice with sigle quotes and inform you the result if it is ok.Thank you again,Warm regards,Dear all,I test with this one ok._ExcelWriteCell($nmc,'=IF(LEFT(B2,1)="1",RIGHT(B2,6)&"/"&RIGHT(B4,19),"")', 2, 3)So, We have to care to sigle quotes (') and double quotes(") in AutoIT. Thank all for your attention.Regards, 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