Leaderboard

Look at _ColorSetRGB, that will convert the 3 color values Red, Green, and Blue to a Decimal number. You can use either Hex representations of the 3 numbers or decimal or any combination of the 2 when you send it to that function. This script was modified from the example script in the help file for _ColorSetRGB that shows what I mean. If you run it in SciTe you can see the value returned by the function in the console output pane of the editor. #include <Color.au3> Dim $aColor[3] = [0x80, 0x90, 255] ; I changed the last value from 0xff to the decimal equivalent to show that it works with both. $nColor = _ColorSetRGB($aColor) ConsoleWrite('@@ Debug(' & @ScriptLineNumber & ') : $nColor = ' & $nColor & @crlf & '>Error code: ' & @error & @crlf) ;### Debug Console MsgBox(4096, "AutoIt", " Red=" & Hex($aColor[0], 2) & " Blue=" & Hex($aColor[1], 2) & " Green=" & Hex($aColor[2], 2) & @CRLF & _ "Color=" & Hex($nColor))

For your button action use something like this: Case $Button1 $oExcel = _ExcelBookOpen($Input1 & "SG Update Vendor Items & Add New Products.xls", 1) If @error = 1 Then MsgBox(0, "Error!", "Unable to Create the Excel Object") Exit ElseIf @error = 2 Then MsgBox(0, "Error!", "File does not exist!") Exit EndIf Add that after the case statement for $GUI_EVENT_CLOSE, add your other buttons as needed using the same format.

You can set a check mark in the menu with GUICtrlSetState( controlID, $GUI_CHECKED ) and clear it with $GUI_UNCHECKED, so if you can live without the square boxes this is an easy solution.

Added a new parameter that will search the string as a literal string. What this means is if you search at present "This text" it will search either for "This" or "text", whereas if you set $iLiteral as 1 it will only search for "This text".

7 day ban for posting yet more homophobic rants after having been warned. Note to all readers: You might be anonymous here, but that does not give you the right to post anything you want. We try to remain civilised here and spouting the kind of garbage this idiot has posted is just not acceptable in any group of which I, and I hope the vast majority of you, want to be part. M23