Rambert

Thanks. I will check later

How can i chek number of rows???

i go bed thanks and regards

Tested at this moment Look my files attached

One advise I have modified function file as i have read here at forum cause i have autoit 3.3.14.0 https://www.autoitscript.com/forum/topic/182286-_excel_rangefind/?do=findComment&comment=1309096

Nothing... I have created a test scripts like help scripts number 1 I have changed only string to find ( 37000 to 99999) I have created a folder named Extras at my folder scripts, and i have copied _Excel1.xls on it. I have pressed F5 and tell me data has been searched... but show me an empty array Could you test it??? thanks and regards

I have read four scripts at help but i must be blind cause I can't get it I will try to read again and if i don't get it, i will post here thanks

Hi everybody. I am using function _Excel_RangeFind to look a value at excel file. That file only has one sheet. There are about 4000 rows and 5 columns. I need to look for a value in that range A1:A4000 and get the rest of values of that row. So i am able to find a value that exists at excel file, but if i look for a value that is not in file how can i manage that error. Resuming if i look for a value in cells range A1:A4000 and it's found, I am able to take the rest of values ( imagine value is found in A130 cell then i can get an array with values in cells A130 B130 C130 D130 E130) but if value is not found in any cell i need show a msgbox and exit program. My problem is when value is not found. I can't manage error. Thanks and regards.

Hi guys. Those examples are not exactly which i need But i have got some ideas to try to make it possible Thanks and regards

Ok thats OK Now another questions And Is possible to get a window into the principal form with messages are being executed with ShellExecuteWait function ??? In my case after get new IP i wanna ping that IP 20 times. And would be possible to get that window???

Hi everybody This my script #include <ButtonConstants.au3> #include <ComboConstants.au3> #include <GUIConstantsEx.au3> #include <GuiIPAddress.au3> #include <StaticConstants.au3> #include <WindowsConstants.au3> $Form1 = GUICreate("Calculo IP", 499, 404, 192, 124) $ButtonOK = GUICtrlCreateButton("Continuar", 96, 344, 75, 33) GUICtrlSetState(-1, $GUI_FOCUS) $ButtonSALIR = GUICtrlCreateButton("Salir", 320, 344, 75, 33) $LabelIPR = GUICtrlCreateLabel("IP ROUTER:", 72, 222, 96, 20) GUICtrlSetFont(-1, 10, 800, 0, "Tahoma") $IPAddressR = _GUICtrlIpAddress_Create($Form1, 280, 220, 130, 21) _GUICtrlIpAddress_Set($IPAddressR, "0.0.0.0") GUISetState(@SW_SHOW) NEWIP () Func NEWIP () Local $aIPROUTER[4] , $aIPNEW[4] , $IPNEW , $IPROUTER Do $nMsg = GUIGetMsg() If $nMsg = $ButtonOK Then $IPROUTER = _GUICtrlIpAddress_Get($IPAddressR) $aIPROUTER = _GUICtrlIpAddress_GetArray($IPROUTER) $aIPNEW[0] = $aIPROUTER[0] $aIPNEW[1] = $aIPROUTER[1] $aIPNEW[2] = $aIPROUTER[2] $aIPNEW[3] = $aIPROUTER[3] + 26 _GUICtrlIpAddress_Set($IPNEW, $aIPNEW[0] & "." & $aIPNEW[1] & "." & $aIPNEW[2] & "." & $aIPNEW[3]) MsgBox($MB_OK, "Calculo IP ", "Old IP is " & $IPROUTER & " New IP is " & $IPNEW ) EndIf Until $nMsg = $ButtonSALIR EndFunc

Dear friends i need your help. I need to change last octect from an IP Address I have created a _GUICtrlIpAddress_Create where I put my IP Address After it I can read it but i need to change last octect , i have to add or subtract some units to last octect So i have though to make it with _GUICtrlIpAddress_GetArray and others like this but i cant get it Any idea how can i do it??? Thanks