LukeJrs

Here is a working template i'm using by nomad ;====================================================================== ; AutoIt Version: 3.1.127 (beta) ; Language: English ; Platform: Win9x/NT or newer ; Author: Nomad ; Requirements: ; This function will only work with beta and my _Mem() functions. ;====================================================================== ; Purpose: ; A demonstration of how to use my Mem() functions. ; This script returns a Diablo II player's name. ;====================================================================== ; Additional: ; Please remember to credit accordingly for any use of this script. ;====================================================================== ;################################## ;Include my Mem() functions ;################################## #include <Memory.au3> ;################################## ;Get the process ID. ;If you get an incorrect reading, ;then you may need administrative ;rights enabled. ;################################## Opt("WinTitleMatchMode", 4) Global $ProcessID = WinGetProcess("ClassName=TNosTaleMainF","") If $ProcessID = -1 Then MsgBox(4096, "ERROR", "Failed to detect process.") Exit EndIf #cs run this to check if you have administrative rights. If Not IsAdmin() Then Msgbox(4096, "Administrative Rights", "You do not have administrative rights.") EndIf #ce ;################################## ;Call the function for reading ;your current strength. ;################################## $PlayerName = Read_Diablo_Memory () MsgBox(4096, "Name", $PlayerName) Exit ;################################## ;Function ;################################## Func Read_Diablo_Memory () ;################################## ;Define Local Variables ;################################## Local $Value ;################################## ;Open the Diablo II process using ;the Process ID retrieved from ;ProcessExists above. ;################################## Local $DllInformation = _MemoryOpen($ProcessID) If @Error Then MsgBox(4096, "ERROR", "Failed to open memory.") Exit EndIf ;################################## ;Read the process and get the ;players name. You need to set ;the 'type' to 'char', and Diablo II ;names can be up to 15 characters in ;length, so you need to put 'char[16]' ;as the parameter. =P ;################################## $Value = _MemoryRead(0x0fce4f28, $DllInformation, 'char[16]') If @Error Then MsgBox(4096, "ERROR", "Failed to read memory.") Exit EndIf ;################################## ;Close the process. ;################################## _MemoryClose($DllInformation) If @Error Then MsgBox(4096, "ERROR", "Failed to close memory.") Exit EndIf ;################################## ;Return the name value. ;################################## Return $Value EndFunc This is Memory.au3 by nomad #include-once #region _Memory ;================================================================================================= ; AutoIt Version: 3.1.127 (beta) ; Language: English ; Platform: All Windows ; Author: Nomad ; Requirements: These functions will only work with beta. ;================================================================================================= ; Credits: wOuter - These functions are based on his original _Mem() functions. But they are ; easier to comprehend and more reliable. These functions are in no way a direct copy ; of his functions. His functions only provided a foundation from which these evolved. ;================================================================================================= ; ; Functions: ; ;================================================================================================= ; Function: _MemoryOpen($iv_Pid[, $iv_DesiredAccess[, $iv_InheritHandle]]) ; Description: Opens a process and enables all possible access rights to the process. The ; Process ID of the process is used to specify which process to open. You must ; call this function before calling _MemoryClose(), _MemoryRead(), or _MemoryWrite(). ; Parameter(s): $iv_Pid - The Process ID of the program you want to open. ; $iv_DesiredAccess - (optional) Set to 0x1F0FFF by default, which enables all ; possible access rights to the process specified by the ; Process ID. ; $if_InheritHandle - (optional) If this value is TRUE, all processes created by ; this process will inherit the access handle. Set to TRUE ; (1) by default. Set to 0 if you want it to be FALSE. ; Requirement(s): A valid process ID. ; Return Value(s): On Success - Returns an array containing the Dll handle and an open handle to ; the specified process. ; On Failure - Returns 0 ; @Error - 0 = No error. ; 1 = Invalid $iv_Pid. ; 2 = Failed to open Kernel32.dll. ; 3 = Failed to open the specified process. ; Author(s): Nomad ; Note(s): ;================================================================================================= Func _MemoryOpen($iv_Pid, $iv_DesiredAccess = 0x1F0FFF, $if_InheritHandle = 1) If Not ProcessExists($iv_Pid) Then SetError(1) Return 0 EndIf Local $ah_Handle[2] = [DllOpen('kernel32.dll')] If @Error Then SetError(2) Return 0 EndIf Local $av_OpenProcess = DllCall($ah_Handle[0], 'int', 'OpenProcess', 'int', $iv_DesiredAccess, 'int', $if_InheritHandle, 'int', $iv_Pid) If @Error Then DllClose($ah_Handle[0]) SetError(3) Return 0 EndIf $ah_Handle[1] = $av_OpenProcess[0] Return $ah_Handle EndFunc ;================================================================================================= ; Function: _MemoryRead($iv_Address, $ah_Handle[, $sv_Type]) ; Description: Reads the value located in the memory address specified. ; Parameter(s): $iv_Address - The memory address you want to read from. It must be in hex ; format (0x00000000). ; $ah_Handle - An array containing the Dll handle and the handle of the open ; process as returned by _MemoryOpen(). ; $sv_Type - (optional) The "Type" of value you intend to read. This is set to ; 'dword'(32bit(4byte) signed integer) by default. See the help file ; for DllStructCreate for all types. ; An example: If you want to read a word that is 15 characters in ; length, you would use 'char[16]'. ; Requirement(s): The $ah_Handle returned from _MemoryOpen. ; Return Value(s): On Success - Returns the value located at the specified address. ; On Failure - Returns 0 ; @Error - 0 = No error. ; 1 = Invalid $ah_Handle. ; 2 = $sv_Type was not a string. ; 3 = $sv_Type is an unknown data type. ; 4 = Failed to allocate the memory needed for the DllStructure. ; 5 = Error allocating memory for $sv_Type. ; 6 = Failed to read from the specified process. ; Author(s): Nomad ; Note(s): Values returned are in Decimal format, unless specified as a 'char' type, then ; they are returned in ASCII format. Also note that size ('char[size]') for all ; 'char' types should be 1 greater than the actual size. ;================================================================================================= Func _MemoryRead($iv_Address, $ah_Handle, $sv_Type = 'dword') If Not IsArray($ah_Handle) Then SetError(1) Return 0 EndIf Local $v_Buffer = DllStructCreate($sv_Type) If @Error Then SetError(@Error + 1) Return 0 EndIf DllCall($ah_Handle[0], 'int', 'ReadProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If Not @Error Then Local $v_Value = DllStructGetData($v_Buffer, 1) Return $v_Value Else SetError(6) Return 0 EndIf EndFunc ;================================================================================================= ; Function: _MemoryWrite($iv_Address, $ah_Handle, $v_Data[, $sv_Type]) ; Description: Writes data to the specified memory address. ; Parameter(s): $iv_Address - The memory address you want to write to. It must be in hex ; format (0x00000000). ; $ah_Handle - An array containing the Dll handle and the handle of the open ; process as returned by _MemoryOpen(). ; $v_Data - The data to be written. ; $sv_Type - (optional) The "Type" of value you intend to write. This is set to ; 'dword'(32bit(4byte) signed integer) by default. See the help file ; for DllStructCreate for all types. ; An example: If you want to write a word that is 15 characters in ; length, you would use 'char[16]'. ; Requirement(s): The $ah_Handle returned from _MemoryOpen. ; Return Value(s): On Success - Returns 1 ; On Failure - Returns 0 ; @Error - 0 = No error. ; 1 = Invalid $ah_Handle. ; 2 = $sv_Type was not a string. ; 3 = $sv_Type is an unknown data type. ; 4 = Failed to allocate the memory needed for the DllStructure. ; 5 = Error allocating memory for $sv_Type. ; 6 = $v_Data is not in the proper format to be used with the "Type" ; selected for $sv_Type, or it is out of range. ; 7 = Failed to write to the specified process. ; Author(s): Nomad ; Note(s): Values sent must be in Decimal format, unless specified as a 'char' type, then ; they must be in ASCII format. Also note that size ('char[size]') for all ; 'char' types should be 1 greater than the actual size. ;================================================================================================= Func _MemoryWrite($iv_Address, $ah_Handle, $v_Data, $sv_Type = 'dword') If Not IsArray($ah_Handle) Then SetError(1) Return 0 EndIf Local $v_Buffer = DllStructCreate($sv_Type) If @Error Then SetError(@Error + 1) Return 0 Else DllStructSetData($v_Buffer, 1, $v_Data) If @Error Then SetError(6) Return 0 EndIf EndIf DllCall($ah_Handle[0], 'int', 'WriteProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If Not @Error Then Return 1 Else SetError(7) Return 0 EndIf EndFunc ;================================================================================================= ; Function: _MemoryClose($ah_Handle) ; Description: Closes the process handle opened by using _MemoryOpen(). ; Parameter(s): $ah_Handle - An array containing the Dll handle and the handle of the open ; process as returned by _MemoryOpen(). ; Requirement(s): The $ah_Handle returned from _MemoryOpen. ; Return Value(s): On Success - Returns 1 ; On Failure - Returns 0 ; @Error - 0 = No error. ; 1 = Invalid $ah_Handle. ; 2 = Unable to close the process handle. ; Author(s): Nomad ; Note(s): ;================================================================================================= Func _MemoryClose($ah_Handle) If Not IsArray($ah_Handle) Then SetError(1) Return 0 EndIf DllCall($ah_Handle[0], 'int', 'CloseHandle', 'int', $ah_Handle[1]) If Not @Error Then DllClose($ah_Handle[0]) Return 1 Else DllClose($ah_Handle[0]) SetError(2) Return 0 EndIf EndFunc ;================================================================================================= ; Function: _MemoryPointerRead ($iv_Address, $ah_Handle, $av_Offset[, $sv_Type]) ; Description: Reads a chain of pointers and returns an array containing the destination ; address and the data at the address. ; Parameter(s): $iv_Address - The static memory address you want to start at. It must be in ; hex format (0x00000000). ; $ah_Handle - An array containing the Dll handle and the handle of the open ; process as returned by _MemoryOpen(). ; $av_Offset - An array of offsets for the pointers. Each pointer must have an ; offset. If there is no offset for a pointer, enter 0 for that ; array dimension. ; $sv_Type - (optional) The "Type" of data you intend to read at the destination ; address. This is set to 'dword'(32bit(4byte) signed integer) by ; default. See the help file for DllStructCreate for all types. ; Requirement(s): The $ah_Handle returned from _MemoryOpen. ; Return Value(s): On Success - Returns an array containing the destination address and the value ; located at the address. ; On Failure - Returns 0 ; @Error - 0 = No error. ; 1 = $av_Offset is not an array. ; 2 = Invalid $ah_Handle. ; 3 = $sv_Type is not a string. ; 4 = $sv_Type is an unknown data type. ; 5 = Failed to allocate the memory needed for the DllStructure. ; 6 = Error allocating memory for $sv_Type. ; 7 = Failed to read from the specified process. ; Author(s): Nomad ; Note(s): Values returned are in Decimal format, unless a 'char' type is selected. ; Set $av_Offset like this: ; $av_Offset[0] = NULL (not used) ; $av_Offset[1] = Offset for pointer 1 (all offsets must be in Decimal) ; $av_Offset[2] = Offset for pointer 2 ; etc... ; (The number of array dimensions determines the number of pointers) ;================================================================================================= Func _MemoryPointerRead ($iv_Address, $ah_Handle, $av_Offset, $sv_Type = 'dword') If IsArray($av_Offset) Then If IsArray($ah_Handle) Then Local $iv_PointerCount = UBound($av_Offset) - 1 Else SetError(2) Return 0 EndIf Else SetError(1) Return 0 EndIf Local $iv_Data[2], $i Local $v_Buffer = DllStructCreate('dword') For $i = 0 to $iv_PointerCount If $i = $iv_PointerCount Then $v_Buffer = DllStructCreate($sv_Type) If @Error Then SetError(@Error + 2) Return 0 EndIf $iv_Address = '0x' & hex($iv_Data[1] + $av_Offset[$i]) DllCall($ah_Handle[0], 'int', 'ReadProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If @Error Then SetError(7) Return 0 EndIf $iv_Data[1] = DllStructGetData($v_Buffer, 1) ElseIf $i = 0 Then DllCall($ah_Handle[0], 'int', 'ReadProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If @Error Then SetError(7) Return 0 EndIf $iv_Data[1] = DllStructGetData($v_Buffer, 1) Else $iv_Address = '0x' & hex($iv_Data[1] + $av_Offset[$i]) DllCall($ah_Handle[0], 'int', 'ReadProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If @Error Then SetError(7) Return 0 EndIf $iv_Data[1] = DllStructGetData($v_Buffer, 1) EndIf Next $iv_Data[0] = $iv_Address Return $iv_Data EndFunc ;================================================================================================= ; Function: _MemoryPointerWrite ($iv_Address, $ah_Handle, $av_Offset, $v_Data[, $sv_Type]) ; Description: Reads a chain of pointers and writes the data to the destination address. ; Parameter(s): $iv_Address - The static memory address you want to start at. It must be in ; hex format (0x00000000). ; $ah_Handle - An array containing the Dll handle and the handle of the open ; process as returned by _MemoryOpen(). ; $av_Offset - An array of offsets for the pointers. Each pointer must have an ; offset. If there is no offset for a pointer, enter 0 for that ; array dimension. ; $v_Data - The data to be written. ; $sv_Type - (optional) The "Type" of data you intend to write at the destination ; address. This is set to 'dword'(32bit(4byte) signed integer) by ; default. See the help file for DllStructCreate for all types. ; Requirement(s): The $ah_Handle returned from _MemoryOpen. ; Return Value(s): On Success - Returns the destination address. ; On Failure - Returns 0. ; @Error - 0 = No error. ; 1 = $av_Offset is not an array. ; 2 = Invalid $ah_Handle. ; 3 = Failed to read from the specified process. ; 4 = $sv_Type is not a string. ; 5 = $sv_Type is an unknown data type. ; 6 = Failed to allocate the memory needed for the DllStructure. ; 7 = Error allocating memory for $sv_Type. ; 8 = $v_Data is not in the proper format to be used with the ; "Type" selected for $sv_Type, or it is out of range. ; 9 = Failed to write to the specified process. ; Author(s): Nomad ; Note(s): Data written is in Decimal format, unless a 'char' type is selected. ; Set $av_Offset like this: ; $av_Offset[0] = NULL (not used, doesn't matter what's entered) ; $av_Offset[1] = Offset for pointer 1 (all offsets must be in Decimal) ; $av_Offset[2] = Offset for pointer 2 ; etc... ; (The number of array dimensions determines the number of pointers) ;================================================================================================= Func _MemoryPointerWrite ($iv_Address, $ah_Handle, $av_Offset, $v_Data, $sv_Type = 'dword') If IsArray($av_Offset) Then If IsArray($ah_Handle) Then Local $iv_PointerCount = UBound($av_Offset) - 1 Else SetError(2) Return 0 EndIf Else SetError(1) Return 0 EndIf Local $iv_StructData, $i Local $v_Buffer = DllStructCreate('dword') For $i = 0 to $iv_PointerCount If $i = $iv_PointerCount Then $v_Buffer = DllStructCreate($sv_Type) If @Error Then SetError(@Error + 3) Return 0 EndIf DllStructSetData($v_Buffer, 1, $v_Data) If @Error Then SetError(8) Return 0 EndIf $iv_Address = '0x' & hex($iv_StructData + $av_Offset[$i]) DllCall($ah_Handle[0], 'int', 'WriteProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If @Error Then SetError(9) Return 0 Else Return $iv_Address EndIf ElseIf $i = 0 Then DllCall($ah_Handle[0], 'int', 'ReadProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If @Error Then SetError(3) Return 0 EndIf $iv_StructData = DllStructGetData($v_Buffer, 1) Else $iv_Address = '0x' & hex($iv_StructData + $av_Offset[$i]) DllCall($ah_Handle[0], 'int', 'ReadProcessMemory', 'int', $ah_Handle[1], 'int', $iv_Address, 'ptr', DllStructGetPtr($v_Buffer), 'int', DllStructGetSize($v_Buffer), 'int', '') If @Error Then SetError(3) Return 0 EndIf $iv_StructData = DllStructGetData($v_Buffer, 1) EndIf Next EndFunc #endregion hope it help ^^

LOL I fix my issue lack of admin provilege ;Function Reference ;IsAdmin ;-------------------------------------------------------------------------------- ;Checks if the current user has full administrator privileges. ;IsAdmin ( ) ;Parameters ;None. ;Return Value ;Success: Returns 1 if the current user has administrator privileges. ;Failure: Returns 0 if user lacks admin privileges. ;Remarks ;It returns 1 under Windows Vista only if running with a full administrator token (i.e. #RequireAdmin has been used, or has already been elevated by UAC). ;Related #RequireAdmin ;Example If IsAdmin() Then MsgBox(0, "", "Admin rights detected") To check if you have admin right type this If IsAdmin() Then MsgBox(0, "", "Admin rights detected") else MsgBox(0, "", "use the #RequireAdmin on include to enable script to run admin in order to show true value.") endif or turn off UAC by going to run then type msconfig --> tool then disable uac lunch or command promp and type C:\Windows\System32\cmd.exe /k %windir%\System32\reg.exe ADD HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System /v EnableLUA /t REG_DWORD /d 0 /f to disable it then restart . you will be all set then u will no longer need the #RequireAdmin Your value should show now ^^

lol just put 0x on it ^^ that how memoryread ^^

doesnt seen to work it still give me null result which is zero.. any other method?

Everytime i tried get an address to read the value i get zero on return value when should be 99 minesweeper I try mess with permedit & setprivilege but i know i'm doing something wrong. #include <NomadMemory.au3> #include <array.au3> #Include <Security.au3> $pid = WinGetProcess("Minesweeper") _Security__SetPrivilege($pid, "Games", "True") MsgBox(0,"","PID: " & $pid ) $OpenProccess = _MemoryOpen($pid) If @error Then MsgBox(0,"error","error opening process.") Exit EndIf $Read = _MemoryRead($OpenProccess, 0x1B13E34, 4); <------i know s a DMA Address. I'm just trying get the value for the address im using cheat engine to get address search everytime i lunch minesweeper If IsArray($Read) Then _ArrayDisplay($Read, "Read Var" ) EndIf MsgBox(0,$Read, $Read) _MemoryClose($OpenProccess) I really need just a basic return value oto the address assing to it.

when it read the doc html it find 239-800-0009 will make it to 2398000009 from $mtn1 = StringReplace($mtn[$i], "-", "");<-----what's this for??

The project i'm working on is focusing getting customer information by phone number on their account so it's scan number by number+1. Example John have an account with Ginzo they can pull his account information with his cellphone. John cell phone is 2398000000 on his account he have 4 line they are, 2398000001,2398000321,2398000004 now the script know how many line he have will save it on a txt file. Unfortunely many duplicate i'm getting such as will go to 2398000001 then will save all 4 line again then will search 2398000002, then 2398000003, once it reach 2398000004 will open john account and will save all 4 line account on txt file. It's there anyway like make a temp file that know which cellphone number already search and not to research same phone number? Func start() $number = InputBox("Feature Finder", "Enter the 10 digit", "Type here", " M10") if $number <= 1000000000 Then start() EndIf $soIE1 = _IECreate("http://Ginzo.west.cust.com", 0, 0) ;OPEN BROWNSER URL For $i1 = 0 To 9999;LOOPING STRING TO REPEAT UNTIL NUMBER REACH ???-???-9999 $sURL1 = "http://Ginzo.west.cust.com/type=searchBy&mtn=" & $number _IENavigate($soIE1, $sURL1);START NAVIGATING $sText = _IEDocReadHTML($soIE1);READ FROM HTML CODE ON WEBSITE $mtn = _StringBetween($sText, 'teleMtn.mtn = "', '";');Mobile Numbers For $i = 0 To UBound($mtn) - 1; maybe $i = 1 if you needn't the count. $mtn1 = StringReplace($mtn[$i], "-", "") Next $number += 1 Next EndFunc

thank you so much...

Thanks work perfect... I tried get this new excel com to work, but wont merge the 2 cell _ExcelCellMerge($oExcel, "True", "A1:B1")

Anyone feel free to help me I would appreciate it

So far i got to this far. #include <ExcelCOM_UDF.au3>; Include the collection #include <Array.au3>; Only for _ArrayDisplay() ; Open new book, make it visible $sFilePath = "L:\AutoIt3\SciTE\Book1.xlsx" Local $oExcel = _ExcelBookOpen($sFilePath) $number = "A1" _ExcelWriteCell($oExcel, "hello", $number) $number += 1 But the thing is I want open the excel if there is data in those cell ignore it and go to next empty cell and continue writing data. Example will write on A1 cell "Hello" then I save it. I try again run macro should write on A2 hello but doesn't it overwrite on cell A1 the information that have on it. I would like to write on the next cell on the existen excel that was open without overwrite the old information cell information.

Original topic was Excel I tried changing script around even making my own still got no success. Well the thing is it work! but the $avFound will not always be hello example on first line could be a phone number second line could be a different phone number. also the one i modified only write hello when should write h on a2, e on a3, l on a4 an so on it only write hello on next line. Example: 2398009999 on A1 <- $avFound will look if this value is on first line 2398770000 on A2<--- this my second line but avFound will not put it second line due doesn't match to A1 Value. I'll post later my work that I made in excel how i wanted to make it look alike. #include <ExcelCOM_UDF.au3>; Include the collection #include <Array.au3>; Only for _ArrayDisplay() ; Open new book, make it visible $sFilePath = "L:\AutoIt3\SciTE\Book1.xlsx" Local $oExcel = _ExcelBookOpen($sFilePath) ; Find $avFound = _ExcelFindInRange($oExcel, "hello", "A1:A100") ;_ArrayDisplay($avFound, "$avFound") ; Write hello to next cell $iNextRow = $avFound[ $avFound[1][0] ][0] + 1 _ExcelWriteCell($oExcel, "hello", $iNextRow, 1) #include <ExcelCOM_UDF.au3>; Include the collection #include <Array.au3>; Only for _ArrayDisplay() ; Open new book, make it visible $sFilePath = "L:\AutoIt3\SciTE\Book1.xlsx" Local $oExcel = _ExcelBookOpen($sFilePath) ; Find $avFound = _ExcelFindInRange($oExcel, "MTN", "A1:A100") ;_ArrayDisplay($avFound, "$avFound") ; Write hello to next cell $iNextRow = $avFound[ $avFound[0][0] ][0] + 1 _ExcelWriteCell($oExcel, "h", $iNextRow, 1) _ExcelWriteCell($oExcel, "e", $iNextRow, 1) _ExcelWriteCell($oExcel, "l", $iNextRow, 1) _ExcelWriteCell($oExcel, "l", $iNextRow, 1) _ExcelWriteCell($oExcel, "o", $iNextRow, 1) _ExcelWriteCell($oExcel, "hello", $iNextRow, 1) What i'm trying to do is make a template of excel like with data that i have storage on the script like $sCustomer = "MARKED PRERED" and $sCustomerOver = " $64.10" The code will run if found customer going over data then will open excel and write customer name and phone number how much is going over ect, the save and close after it's done the program will keep looking for new customer info to save it to next line in excel and not overwrite the first line information. can you be able point me some dirrection where should i got to learn this excel com or walk me through step? package.zip

Anyone can help me or point me dirrection where to start?

What i'm trying to do is make a template of excel like with data that i have storage on the script like $sCustomer = "MARKED PRERED" and $sCustomerOver = " $64.10" The code will run if found customer going over data then will open excel and write customer name and phone number how much is going over ect, the save and close after it's done the program will keep looking for new customer info to save it to next line in excel and not overwrite the first line information. can you be able point me some dirrection where should i got to learn this excel com or walk me through step? Thank for your time. package.zip

I tried changing script around even making my own still got no success. Well the thing is it work! but the $avFound will not always be hello example on first line could be a phone number second line could be a different phone number. also the one i modified only write hello when should write h on a2, e on a3, l on a4 an so on it only write hello on next line. Example: 2398009999 on A1 <- $avFound will look if this value is on first line 2398770000 on A2<--- this my second line but avFound will not put it second line due doesn't match to A1 Value. I'll post later my work that I made in excel how i wanted to make it look alike. #include <ExcelCOM_UDF.au3>; Include the collection #include <Array.au3>; Only for _ArrayDisplay() ; Open new book, make it visible $sFilePath = "L:\AutoIt3\SciTE\Book1.xlsx" Local $oExcel = _ExcelBookOpen($sFilePath) ; Find $avFound = _ExcelFindInRange($oExcel, "hello", "A1:A100") ;_ArrayDisplay($avFound, "$avFound") ; Write hello to next cell $iNextRow = $avFound[ $avFound[1][0] ][0] + 1 _ExcelWriteCell($oExcel, "hello", $iNextRow, 1) #include <ExcelCOM_UDF.au3>; Include the collection #include <Array.au3>; Only for _ArrayDisplay() ; Open new book, make it visible $sFilePath = "L:\AutoIt3\SciTE\Book1.xlsx" Local $oExcel = _ExcelBookOpen($sFilePath) ; Find $avFound = _ExcelFindInRange($oExcel, "MTN", "A1:A100") ;_ArrayDisplay($avFound, "$avFound") ; Write hello to next cell $iNextRow = $avFound[ $avFound[0][0] ][0] + 1 _ExcelWriteCell($oExcel, "h", $iNextRow, 1) _ExcelWriteCell($oExcel, "e", $iNextRow, 1) _ExcelWriteCell($oExcel, "l", $iNextRow, 1) _ExcelWriteCell($oExcel, "l", $iNextRow, 1) _ExcelWriteCell($oExcel, "o", $iNextRow, 1) _ExcelWriteCell($oExcel, "hello", $iNextRow, 1)