Trouble with Function in If then statement

[dar100111]

I've tested my variable many different ways and I think there's a syntax problem that I just don't know how to deal with.

How do you correctly start the _ie function in this statement?  Is there a trick.  My variables do equal each other and I've verified. 

Thanks in advance!

If $prefix = $currentbranch Then _ExcelWriteCell($oExcel, $consolwgt, $row, 2)

[DW1]

  On 6/5/2013 at 6:07 PM, dar100111 said:

I've tested my variable many different ways and I think there's a syntax problem that I just don't know how to deal with.

How do you correctly start the _ie function in this statement?  Is there a trick.  My variables do equal each other and I've verified. 

Thanks in advance!

If $prefix = $currentbranch Then _ExcelWriteCell($oExcel, $consolwgt, $row, 2)

Please post more of your code than this for quicker assistance.  What you have posted looks fine, but could be wrong depending on how the variables are populated above this line.

[dar100111]

Thanks Unbalanced.  Everything writes fine to my file except the If Then statements where $prefix = $currentbranch.  The function works fine on it's own so I'm thinking it's syntax.

If $value = 1 Then;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;GET SYSTEM INFORMATION;;;;;;;;;;;;;;;;;;;;;;;;1
$oExcel = _ExcelBookOpen("F:EIDFWNATOracle NMCNMC DevelopmentNetwork AnalystReportsautoitfwdnbulkbook.xlsx")
$aArray = _ExcelReadSheetToArray($oExcel)
$counter = $aArray[0][0]
$currentbranch = $aArray[2][17]
$gci = "GCI"
Do
$eiref = $aArray[$row][1]
IF WinExists("EXPORT dfw") Then
 WinActivate("EXPORT dfw")
 ControlSend("EXPORT dfw","","","{PGUP}")
 ControlSend("EXPORT dfw","","","LOG  ")
 ControlSend("EXPORT dfw","","",$eiref)
 ControlSend("EXPORT dfw","","TScrollBox1","{F8}")
 ControlSend("EXPORT dfw","","TScrollBox1","{F8}")
 DO
 $prefix = StringTrimLeft($eiref, 3)
 $file = StringTrimRight(ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:76]"), 7)
 $org = ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:73]")
 $dest = ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:70]")
 $pcs = ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:7]")
 $wgt = ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:4]")
 $consolwgt = ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:3]")
 $descrip = ControlGetText("EXPORT dfw", "", "[CLASS:TEIEdit; INSTANCE:55]")
 Until $file = $eiref
 _ExcelWriteCell($oExcel, $wgt, $row, 2)
 If $prefix = $currentbranch Then _ExcelWriteCell($oExcel, $consolwgt, $row, 2)
 _ExcelWriteCell($oExcel, $pcs, $row, 3)
 _ExcelWriteCell($oExcel, $org, $row, 4)
 _ExcelWriteCell($oExcel, $dest, $row, 5)
 _ExcelWriteCell($oExcel, $descrip, $row, 6)
 If $prefix = $currentbranch Then _ExcelWriteCell($oExcel, "Freight All Kinds", $row, 6)
  Else
  MsgBox(0x10000,"Error","Open an EXPORT screen.")
  Exit
 EndIf
$row = $row + 1
Until $row = $counter + 1
MsgBox("","System Information Gathered", "Shipment Info from Export Complete!")
EndIf

[BrewManNH]

Add this in your script after one of the conditional statements and see if you get the right message box to pop up.

 

If $prefix = $currentbranch Then
    MsgBox($MB_SYSTEMMODAL, "Match", "They match")
Else
    MsgBox($MB_SYSTEMMODAL, "No Match", "They don't match")
EndIf

[dar100111]

Hey Brewman. I should have done that inseat of a messagebox with my variable. There was a space on the end that I couldn't see. I'll do that next time. Thanks!