Leaderboard

You could try optimizing your code to see if that improves the speed. A few areas to investigate -- Use _ArraySearch / _ArrayBinarySearch instead of manual looping Perform actions once instead of every pass through the array StringStripWS could be used to clean the array once UBound could be saved to a variable and then reuses

Hello, the Excel.au3 UDF is interacting with the Excel application. Maybe one of the authors can jump in to answer, if the speed is limited by this "Excel Remoting"? (See header -> author in excel.au3) Quite a while ago I noticed, that using powershell to convert excel files to CSV files, then work with these CSV files, is to me easier and much faster. Have a look at this free powershell module, that even doesn't need the Excel application to be installed: https://www.powershellgallery.com/packages/ImportExcel/7.8.6 I use that one in conjunction with Autoit to process the data, that I need do plot to a temperature graph (image). import-excel $XLfile -WorksheetName $WSName| convertto-csv -notypeinfo | out-file $CSVFPFN -encoding utf8 Maybe doing the replacements using regex line by line (instead of array-cell-by-cell) might speedup the procedure? You also might look at the results, when placing in your loops some consolewrites to follow up the speed: ConsoleWrite("ScriptLine: " & @ScriptLineNumber & ", $i = " & $i & @CRLF)

can you treat it as a database or use SQLite ?

That doesn't surprise me since AutoIt is single threaded. Have you isolated which section of code is causing the slowdown?

It looks like it is now fixed. Thanks.

Thanks for the zip file. Please try the uploaded AutoItGotoDefinition.lua to see if that makes any difference. Add directive to your code: #SciTE4AutoIt3_AutoItGotoDefinition_debug=y test the goto UDF and have a look at SciTE_LUA_Scripts_Debug.err for the details and send that to me in case there is still an issue.

@Blaxxun You should consider giving solution to mikell instead of yourself...if you understand what I mean.

It seems that you need this : _GUICtrlComboBox_BeginUpdate

Updated the initial post with a link to the latest updated SciTE4AutoIt3 beta installer and portable zip file. These contain all the current/latest versions so no need for other stuff after the update. Don't forget to make a Backup first to ensure there is an easy rollback in case of issues. Jos