dickjones007

i can select more/all items but they cannot be copied at once. there is no "copy" in context menu. ctrl-c works but only copies last clicked field.

love your thinking, but our IT manager is such a "specialist" who doesnt believe his own mother. i asked him about read-only rights to database and explained to him what i want to do and how useful it will be. he only gave some bullshit which summoned up to a "you dont really need that, do it the hard way".

yes it loads that table from mysql database to which i have no access nor will i get it is there maybe any friendly way to access it that i dont know of?

in the upper right part of video there is text in the "table app" saying "Zapis #/22" i can read that text with : ControlGetText("Materijalno knjigovodstvo - [Odabir artikla 1]", "", 66446) with 66446 being the ID of that control but when trying ID 66430 (ID of main table) i get nothing in the msgbox

i am trying to make automatic order filling app by just scanning products barcode only thing i have trouble with is active state of warehouse items which i am trying to resolve by exporting table from my company's software to excel

@BrewManNH im trying to transfer entire table to excel so i can work with it @JohnOne what do you mean? i have also been trying with control get text but no result

attached a video of script doing its thing is there any other way of doing this to significantly increase speed table has 20000+ rows which will roughly take ~18hrs to complete the process code: #include <excel.au3> Local $sFilePath1 = @ScriptDir & "\Test.xlsx" Local $oExcel = _ExcelBookOpen($sFilePath1,1) WinWaitActive("Microsoft Excel - test") WinActivate("Materijalno knjigovodstvo - [Odabir artikla 1]") Send("^{HOME}") ;goes to first row of entire table Send("{HOME}") ;goes to begining of row $brojredova = StringRight(ControlGetText("Materijalno knjigovodstvo - [Odabir artikla 1]", "", 66446), 5) ;reads the number of rows $hTimer = TimerInit() For $i = 0 To 5 ;row by row (5 will be replaced with $brojredova) For $j = 0 To 4 ;column by column (without the last one) WinActivate("Materijalno knjigovodstvo - [Odabir artikla 1]") Send("^c") ;copies selected field value _ExcelWriteCell($oExcel, ClipGet(), $i + 1, $j + 1) Send("{RIGHT}") ;select next right vaule Next Send("{DOWN}") ;goes to next row Send("{HOME}") ;goes to beginning of row Next $iDiff = TimerDiff($hTimer) MsgBox(0, "Time Difference", $iDiff/1000) ;~ WinActivate("Microsoft Excel - test") ;~ Sleep(100) _ExcelBookSave($oExcel) _ExcelBookClose($oExcel) cannot select entire row taking questions and suggestions. C41686700260.rar

clearer slow is good

headers didnt went unread i just didnt understand some of them looking at your reply focusing my mind on that green text i still have no idea how to construct the script for checkbox i could use $GUI_CHECKED on every row?

when using $LVS_EX_CHECKBOXES is it possible to save chckbox state when saving listview content to .ini or .txt file? and then restore chckbox state when reloading file to listview?

thanks for help. made it work.

txt file example attached what's the easiest/fastest way of that info to be imported into listview by some predictions my listview will have maximum of 200 rows. column separator is "|" im using melba's UDF GUIListViewEx.au3 for listview controls i am successfully using _GUIListViewEx_ReadToArray to export listview to that text file i dont know if function _GUIListViewEx_ReturnArray is used to import values to listview tried some combination but couldnt get it to work. can anyone help? also i think melba helped me with this. test array.txt

words of inspiration noted will continue help file in full details maybe found another bug for your UDF so i tried combination 1 + 2 + 4 + 8 for $iAdded and when editing Ctrl-click on header it only accepts edited value with ENTER even thou i included + 4

srry, but to tell you the truth it was the last thing on my mind to look for help in the UDF itself. but now im thinking differently right now im in the process of writing help file for my finished app and honestly i ask my self the same question. is it worth the trouble?

didnt look in all 8 pages of this thread so pardon me if it has been asked. is it possible in edit mode to keep the entered value without pressing ENTER? for example if i double click to edit an item and then click somewhere else, without confirming entered value with ENTER, then that value is lost