JanZoudlik

Hi Melba, No need to apologies... Anyway, thanks for quick reply and suggestion. I will use limit at least to stop users going into negative values... Thanks Jan

Hi Melba23, is there a way with your awesome UDF to limit UpDown of each row individually? As per your previously provided example to me, you set limit per column. Unfortunately i do need limit per row. Any chance this can be somehow done? I am failing to figure this one out... Thanks Jan

Hi Melba, great work on this as always... I use old version of this UDF but I guess I will have to upgrade as I need some features from your new version. To be more exact I need one column to have updown control. And I struggle to figure out how to SetEditStatus so it has UpDown controls next to number and further to that how can I limit range(for example so it goes from 1 to 6). Any help would be appreciated... Thanks a lot Jan

Hello everyone, here is my little contribution to AutoIt community. I was looking for a way to print tables from my scripts. None of the solutions was exactly working for me as there were always some limitations. If you need to be able to print table, while making sure that header is printed on each page (if large table), rows won't split up(across several pages) and you want to be able to adjust table size on page or each column size, you in the right place. Also you can choose between landscape and portrait mode It uses a browser to print table out. Simply, it generates a html file which is then open within browser and it initialize print. This version is tested with Chrome browser... Please be aware that there is a bug. When you try to disable row numbers, it will also remove table borders(lines). If anybody can figure out why, it would be appreciated by me and I am sure by others as well. Enjoy Jan UPDATE: found today that geniuses from Google stopped following standards and it no longer prints correctly with Chrome. It also ignores the portrait/landscape settings. However, I tested it with latest IE on Win 7 and it works fine!!! so I suggest you use IE to print... In case you don't have IE as main browser and you do have issues with your current browser then replace shellexecute and winwaitactive at the end of function with: local $hIE=run('"C:\Program Files\Internet Explorer\iexplore.exe" "' & $sFile & '"') ProcessWait($hIE) ; AutoIt Version: 3.3.10 ; Language: English ; Platform: Win ; Author: Jan Zoudlik ; NOTE: big thanks to DoctorDestructo from http://stackoverflow.com/ for main script with css styling etc ; and guinness, tproli, Lupo73 from https://www.autoitscript.com/forum/ for inspiration with their listview to html function ; Script Function: ; table print - example + _table_print function #include <File.au3> Local $aTestArray[4][4] = [[20, 50, 20, 7], ["head", "heading<br/>accross two lines", "heading", "X"],["data row 1",5,"data",6],["data row 2",5&"<br/>"&6,"data",6]] _table_print("test title",100,$aTestArray,True) Func _table_print($Title,$Table_Size,ByRef $2D_array, $Landscape=True, $Row_Numbers=True) ;table that will print as table should (tested with chrome and ie browsers)> header on each page, table cell won't be printed across two pages > so even multi line row will always stay on one page or will be as whole pushed to next page ;to break the line within the cell or heading use "<br/>" not @LF or @CRLF as it is html... if word within cell is wider then column width it will adjust columnm width so word will fit, it will auto(line)break sentance if wider than column ;the allingment withing table is : vertical middle - horizontal left(header is vertical down - horizontal middle) and row numbers are vertical middle - horizontal right... sufficient for me... ;file name automatically generated and saved in temp folder ;Title - self explaining - displayed on the top of the table on first page only ;Table_Size - in percent - how big table(width) should be compare to the paper size so 100 - table will spread accross whole paper printable area, 50 - table size will be approx half of the paper size ;2D_array - row 0, number in percent per each column (width of column) - all together it should add up 100%(97% if row_numbers are used as 3% is used as size for row count column) ;2D_array - row 1, column header - will repeat on each page ;2D_array - row 2-n, data ;$Row_Numbers - first column will contain row number(so there will be one extra column in table) ;$Landscape - to print in landscape or portrait mode... ;paper size is as per printer settings ;font size is set to 10; if adjustment needed for blind people, then search for font-size: 10px; and don't forget to also adjust line-height: 13px accordingly(so it is bigger than font) ;_table_print function CREATED BY Jan Zoudlik ;big thanks to DoctorDestructo from http://stackoverflow.com/ for main script with css styling etc and guinness, tproli, Lupo73 from https://www.autoitscript.com/forum/ for inspiration with their listview to html function $sHTMLTable='<!DOCTYPE html>' & @CRLF & _ '<html>' & @CRLF & _ ' <body>' & @CRLF & _ ' <table ' if $Row_Numbers then $sHTMLTable=$sHTMLTable & 'class="print t1" ' $sHTMLTable=$sHTMLTable & 'width="' & $Table_Size & '%"> <!-- Delete "t1" class to remove row numbers. -->' & @CRLF & _ ' <caption>' & $Title & '</caption>' & @CRLF if $Row_Numbers then $sHTMLTable=$sHTMLTable & ' <col width="3%">' & @CRLF for $column=0 to ubound($2D_array,2)-1 $sHTMLTable=$sHTMLTable & ' <col width="' & $2D_array[0][$column] & '%">' & @CRLF Next $sHTMLTable=$sHTMLTable & ' <thead>' & @CRLF & _ ' <tr>' & @CRLF if $Row_Numbers then $sHTMLTable=$sHTMLTable & ' <th>#</th>' & @CRLF for $column=0 to ubound($2D_array,2)-1 $sHTMLTable=$sHTMLTable & ' <th>' & $2D_array[1][$column] & '</th>' & @CRLF Next $sHTMLTable=$sHTMLTable & ' </tr>' & @CRLF & _ ' </thead>' & @CRLF & _ ' <tbody>' & @CRLF for $row=2 to ubound($2D_array)-1 $sHTMLTable=$sHTMLTable & ' <tr>' & @CRLF if $Row_Numbers then $sHTMLTable=$sHTMLTable & ' <td></td>' & @CRLF for $column=0 to ubound($2D_array,2)-1 $sHTMLTable=$sHTMLTable & ' <td>' & $2D_array[$row][$column] & '</td>' & @CRLF Next $sHTMLTable=$sHTMLTable & ' </tr>' & @CRLF Next $sHTMLTable=$sHTMLTable & ' </tbody>' & @CRLF & _ ' </table>' & @CRLF & _ ' </body>' & @CRLF & _ '</html>' & @CRLF $sCSSstyle='<style>' & @CRLF & _ ' /* THE FOLLOWING CSS IS REQUIRED AND SHOULD NOT BE MODIFIED. */' & @CRLF & _ ' div.fauxRow {' & @CRLF & _ ' display: inline-block;' & @CRLF & _ ' vertical-align: top;' & @CRLF & _ ' width: 100%;' & @CRLF & _ ' page-break-inside: avoid;' & @CRLF & _ ' }' & @CRLF & _ ' table.fauxRow {border-spacing: 0;}' & @CRLF & _ ' table.fauxRow > tbody > tr > td {' & @CRLF & _ ' padding: 0;' & @CRLF & _ ' overflow: hidden;' & @CRLF & _ ' }' & @CRLF & _ ' table.fauxRow > tbody > tr > td > table.print {' & @CRLF & _ ' display: inline-table;' & @CRLF & _ ' vertical-align: top;' & @CRLF & _ ' }' & @CRLF & _ ' table.fauxRow > tbody > tr > td > table.print > caption {caption-side: top;}' & @CRLF & _ ' .noBreak {' & @CRLF & _ ' float: right;' & @CRLF & _ ' width: 100%;' & @CRLF & _ ' visibility: hidden;' & @CRLF & _ ' }' & @CRLF & _ ' .noBreak:before, .noBreak:after {' & @CRLF & _ ' display: block;' & @CRLF & _ ' content: "";' & @CRLF & _ ' }' & @CRLF & _ ' .noBreak:after {margin-top: -594mm;}' & @CRLF & _ ' .noBreak > div {' & @CRLF & _ ' display: inline-block;' & @CRLF & _ ' vertical-align: top;' & @CRLF & _ ' width:100%;' & @CRLF & _ ' page-break-inside: avoid;' & @CRLF & _ ' }' & @CRLF & _ ' /*table.print > thead {white-space: nowrap;}*/ /* Uncomment if line-wrapping causes problems. */' & @CRLF & _ ' table.print > tbody > tr {page-break-inside: avoid;}' & @CRLF & _ ' table.print > tbody > .metricsRow > td {border-top: none !important;}' & @CRLF & _ '' & @CRLF & _ ' /* THE FOLLOWING CSS IS REQUIRED, but the values may be adjusted. */' & @CRLF & _ ' /* NOTE: All size values that can affect an elements height should use the px unit! */' & @CRLF & _ ' table.fauxRow, table.print {' & @CRLF & _ ' font-size: 10px;' & @CRLF & _ ' line-height: 13px;' & @CRLF & _ ' }' & @CRLF & _ '' & @CRLF & _ ' /* THE FOLLvOWING CSS IS OPTIONAL. */' & @CRLF if $Landscape then $sCSSstyle=$sCSSstyle & ' @page {size: landscape;} /* Delete to print in portrait mode*/' & @CRLF if $Row_Numbers then $sCSSstyle=$sCSSstyle & ' body {counter-reset: t1;} /* Delete to remove row numbers. */' & @CRLF & _ ' .noBreak .t1 > tbody > tr > :first-child:before {counter-increment: none;} /* Delete to remove row numbers. */' & @CRLF & _ ' .t1 > tbody > tr > :first-child:before { /* Delete to remove row numbers. */' & @CRLF & _ ' display: block;' & @CRLF & _ ' text-align: right;' & @CRLF & _ ' counter-increment: t1 1;' & @CRLF & _ ' content: counter(t1);' & @CRLF & _ ' }' & @CRLF $sCSSstyle=$sCSSstyle & ' table.fauxRow, table.print {' & @CRLF & _ ' font-family: Tahoma, Verdana, Georgia; /* Try to use fonts that dont get bigger when printed. */' & @CRLF & _ ' margin: 0 auto 0 auto; /* Delete if you dont want table to be centered. */' & @CRLF & _ ' }' & @CRLF & _ ' table.print {border-spacing: 0;}' & @CRLF & _ ' table.print > * > tr > * {' & @CRLF & _ ' border-right: 1px solid black;' & @CRLF & _ ' border-bottom: 1px solid black;' & @CRLF & _ ' padding: 0 3px 0 3px;' & @CRLF & _ ' }' & @CRLF & _ ' table.print > * > :first-child > * {border-top: 1px solid black;}' & @CRLF & _ ' table.print > thead ~ * > :first-child > *, table.print > tbody ~ * > :first-child > * {border-top: none;} ' & @CRLF & _ ' table.print > * > tr > :first-child {border-left: 1px solid black;}' & @CRLF & _ ' table.print > thead {vertical-align: bottom;}' & @CRLF & _ ' table.print > thead > .borderRow > th {border-bottom: none;}' & @CRLF & _ ' table.print > tbody {vertical-align:middle;}' & @CRLF & _ ' table.print > caption {font-weight: bold;}' & @CRLF & _ '</style>' & @CRLF & _ '' & @CRLF & _ '<script>' & @CRLF & _ '' & @CRLF & _ ' (function() { // THIS FUNCTION IS REQUIRED.' & @CRLF & _ ' if(/Firefox|MSIE |Trident/i.test(navigator.userAgent))' & @CRLF & _ ' var formatForPrint = function(table) {' & @CRLF & _ ' var noBreak = document.createElement("div")' & @CRLF & _ ' , noBreakTable = noBreak.appendChild(document.createElement("div")).appendChild(table.cloneNode())' & @CRLF & _ ' , tableParent = table.parentNode' & @CRLF & _ ' , tableParts = table.children' & @CRLF & _ ' , partCount = tableParts.length' & @CRLF & _ ' , partNum = 0' & @CRLF & _ ' , cell = table.querySelector("tbody > tr > td");' & @CRLF & _ ' noBreak.className = "noBreak";' & @CRLF & _ ' for(; partNum < partCount; partNum++) {' & @CRLF & _ ' if(!/tbody/i.test(tableParts[partNum].tagName))' & @CRLF & _ ' noBreakTable.appendChild(tableParts[partNum].cloneNode(true));' & @CRLF & _ ' }' & @CRLF & _ ' if(cell) {' & @CRLF & _ ' noBreakTable.appendChild(cell.parentNode.parentNode.cloneNode()).appendChild(cell.parentNode.cloneNode(true));' & @CRLF & _ ' if(!table.tHead) {' & @CRLF & _ ' var borderRow = document.createElement("tr");' & @CRLF & _ ' borderRow.appendChild(document.createElement("th")).colSpan="1000";' & @CRLF & _ ' borderRow.className = "borderRow";' & @CRLF & _ ' table.insertBefore(document.createElement("thead"), table.tBodies[0]).appendChild(borderRow);' & @CRLF & _ ' }' & @CRLF & _ ' }' & @CRLF & _ ' tableParent.insertBefore(document.createElement("div"), table).style.paddingTop = ".009px";' & @CRLF & _ ' tableParent.insertBefore(noBreak, table);' & @CRLF & _ ' };' & @CRLF & _ ' else' & @CRLF & _ ' var formatForPrint = function(table) {' & @CRLF & _ ' var tableParent = table.parentNode' & @CRLF & _ ' , cell = table.querySelector("tbody > tr > td");' & @CRLF & _ ' if(cell) {' & @CRLF & _ ' var topFauxRow = document.createElement("table")' & @CRLF & _ ' , fauxRowTable = topFauxRow.insertRow(0).insertCell(0).appendChild(table.cloneNode())' & @CRLF & _ ' , colgroup = fauxRowTable.appendChild(document.createElement("colgroup"))' & @CRLF & _ ' , headerHider = document.createElement("div")' & @CRLF & _ ' , metricsRow = document.createElement("tr")' & @CRLF & _ ' , cells = cell.parentNode.cells' & @CRLF & _ ' , cellNum = cells.length' & @CRLF & _ ' , colCount = 0' & @CRLF & _ ' , tbods = table.tBodies' & @CRLF & _ ' , tbodCount = tbods.length' & @CRLF & _ ' , tbodNum = 0' & @CRLF & _ ' , tbod = tbods[0];' & @CRLF & _ ' for(; cellNum--; colCount += cells[cellNum].colSpan);' & @CRLF & _ ' for(cellNum = colCount; cellNum--; metricsRow.appendChild(document.createElement("td")).style.padding = 0);' & @CRLF & _ ' cells = metricsRow.cells;' & @CRLF & _ ' tbod.insertBefore(metricsRow, tbod.firstChild);' & @CRLF & _ ' for(; ++cellNum < colCount; colgroup.appendChild(document.createElement("col")).style.width = cells[cellNum].offsetWidth + "px");' & @CRLF & _ ' var borderWidth = metricsRow.offsetHeight;' & @CRLF & _ ' metricsRow.className = "metricsRow";' & @CRLF & _ ' borderWidth -= metricsRow.offsetHeight;' & @CRLF & _ ' tbod.removeChild(metricsRow);' & @CRLF & _ ' tableParent.insertBefore(topFauxRow, table).className = "fauxRow";' & @CRLF & _ ' if(table.tHead)' & @CRLF & _ ' fauxRowTable.appendChild(table.tHead);' & @CRLF & _ ' var fauxRow = topFauxRow.cloneNode(true)' & @CRLF & _ ' , fauxRowCell = fauxRow.rows[0].cells[0];' & @CRLF & _ ' fauxRowCell.insertBefore(headerHider, fauxRowCell.firstChild).style.marginBottom = -fauxRowTable.offsetHeight - borderWidth + "px";' & @CRLF & _ ' if(table.caption)' & @CRLF & _ ' fauxRowTable.insertBefore(table.caption, fauxRowTable.firstChild);' & @CRLF & _ ' if(tbod.rows[0])' & @CRLF & _ ' fauxRowTable.appendChild(tbod.cloneNode()).appendChild(tbod.rows[0]);' & @CRLF & _ ' for(; tbodNum < tbodCount; tbodNum++) {' & @CRLF & _ ' tbod = tbods[tbodNum];' & @CRLF & _ ' rows = tbod.rows;' & @CRLF & _ ' for(; rows[0]; tableParent.insertBefore(fauxRow.cloneNode(true), table).rows[0].cells[0].children[1].appendChild(tbod.cloneNode()).appendChild(rows[0]));' & @CRLF & _ ' }' & @CRLF & _ ' tableParent.removeChild(table);' & @CRLF & _ ' }' & @CRLF & _ ' else' & @CRLF & _ ' tableParent.insertBefore(document.createElement("div"), table).appendChild(table).parentNode.className="fauxRow";' & @CRLF & _ ' };' & @CRLF & _ ' var tables = document.body.querySelectorAll("table.print")' & @CRLF & _ ' , tableNum = tables.length;' & @CRLF & _ ' for(; tableNum--; formatForPrint(tables[tableNum]));' & @CRLF & _ ' })();' & @CRLF & _ '</script>' $sFile=_TempFile ( @TempDir , "~", ".html" ) ;~ $sFile= @ScriptDir & "\Export.html" $hFile= FileOpen($sFile, 2 + 8) FileWrite($hFile,$sHTMLTable & $sCSSstyle) FileClose($hFile) If @error Then msgbox(0,"Print Error","Failed to close the file!") EndIf ShellExecute($sFile) WinWaitActive(StringTrimLeft($sFile,StringInStr($sFile,"\","",-1))) send("^p") EndFunc ;==>_table_print

Hi Melba, I believe that it doesn't work for me as I am reading listview out using _GUIListViewEx_ReturnArray and changing several values using _GUIListViewEx_ChangeItem. During this I have noticed that listview refreshes. I can only assume that it is a root cause of the issue as it possibly somehow overwrites GUImsg. I haven't test it nor investigated further. Current resolution works great for me and it is sufficient as all buttons are fully responsive as they should. Once again I want to thank you for great work and awesome support! PS: May I ask if your msgbox is waiting for enter/mouse key to be released prior to function return? Regards Jan

Hi Melba, sorry for late reply... technically editing starts automatically waiting for customers input and GUI buttons which don't work are back, logout and exit which all of them are self explaining. I apologies that I did not provide original script. It would never work for you as it is connecting to three different MS SQL databases and strip it down would be very difficult. Bottom line is that issue it suffered from was basically same issue(similar) as close button did. In my case as script is quite complicated , for some reason, it ignores button press completely. Likely because I am reading array out, changing values within list view etc... I came up with very simple fix which works great for me. I created global variable $GLVEx_iMsg and added/modified line 2321(the beginning of edit loop within UDF within _GUIListViewEx_EditProcess) so it is as following: $GLVEx_iMsg=0 While 1 $GLVEx_iMsg=GUIGetMsg() if $GLVEx_iMsg<>0 then ExitLoop then within my script I test for $GLVEx_iMsg as well as standard $iMsg which I fill in at the beginning of my loop($iMsg=GUIGetMsg()). This works perfectly for me apart of actual close button. For that I have used your fix as suggested within modified UDF. I um unsure if this will work with combo box or while moving up and down etc as I don't use it. Might help others possibly facing similar issue within more complex scripts... Yet again thanks for your great work and very quick response... Regards Jan

Hi there, didn't have chance to do full testing yet to find out what exactly is causing it... Anyway all your included examples suffer from same issue > start editing and then hit close button > script will indeed close window however not straight away as it should. example number 1 > start editing using buttons and keep changing what you want to edit using buttons(just pressing buttons with mouse) > eventually it will start playing up... I'll get back to you once I find out(ensure what) root cause and find work around or fix... Regards Jan P.S.: just tested your script which you have posted and it also suffers same issue... further more you did not read my original post correctly as I mentioned issue with _GUIListViewEx_EditItem; you don't use it in posted script at all...

Hi Melba, are you ever away from PC? Always so quick in replies... I am aware of suggested concepts of interrupting running functions and AutoIt limitations, yet still I don't think it will complicate the code that much(using 2. suggested option; 1. suggested option would be of course complex and complicated). As I a mentioned before I will post modified UDF version where I will clearly mark all the changes I will do, it will be up to you if you like it or not... To your question why does user need an immediate response? Well simply, because if buttons won't respond on first click then it is a bug. It can be fixed by temporary disabling them which I considered as first option, however it is not option I like as I believe that software should be always as user friendly as possible, which is prime! This applies even if it adds extra thousand lines into the code! I hope I will have chance to look into it tomorrow... Regards Jan

Hi Melba, using your UDF and it works great, however I found a minor limitation which causing user inconvenience... I would suggest to overcome it as it will make your UDF even better Within GUI I have created(message loop mode) I have also created several buttons as well as list view and once I call _GUIListViewEx_EditItem all the buttons will stop responding as function is stuck within it's own loop. I can think of two options how to overcome this limitation: 1. split internally function down into a 3 sections. Something like init, loop and final, where function will internally ensures that init is run first time it goes through, after that loop section is being launched each time it is called until appropriate keys hit and then it launches final section which will keep returning result until actioned. Or actually physically break it down into separate functions... This way the main script loop will be used for this and therefore everything else will work as well. 2. pull GUIGetMsg() inside functions loop and if changed exit editing and return it so it can be processed within main script loop I will likely go for the 2nd option as it makes it significantly easier for me to modify your UDF, however 1st option will likely have more sense for others... Or do you have any other suggestion? for example how can I actually set GUI message (something like GUISetMsg as it would be the best option for everyone > exit editing and fake GUI message so it is picked up automatically in next loop without need of another variable) I will hopefully have a time to look into it tomorrow. I will post modified UDF once done Thanks Jan

I kind of miss that... Used to have a lot of fun back at school while programming intel 8086 microproccesor family. It was at the time code actually had to be optimized for performance due to very limited power Bring also memories about Borland Pascal in conjunction with assembler, I used to love that programming language...

Hi Melba, yeah I realized that... anyway, easiest way to clear a buffer is still assembly code: mov ah,08h int 21h which should work in conjunction with https://www.autoitscript.com/forum/topic/86672-autoit-inline-assembly-udf/ (I did not tested this...) I went through so many programming and scripting languages that it is all mixed up... If I recall it correctly some of them actually used to clear buffer automatically when command initiating keyboard input was called. But hey, this is autoIt and therefore my bad... Sorry about that... And yet again thanks for you quick response Regards Jan

Hi there, nothing particular, just clicking the button using mouse and then clicking enter escape etc... Anyway, if you click enter at some point while your script runs it will do it also. It is like if value is hanging in keyboard buffer waiting to be read out...

Hi M23, I found yet again strange behavior if in "loop mode" especially when edit initialized by a button. This is nothing what would stop me from using your UDF however as a bug it should be looked as it can cause troubles to somebody else. Incomplete bit of code, how I managed to replicate an issue is placed below... All you need to do is somehow fill $aTemp 2d array with random data to get it to work. I actually load it from SQL database so I removed that bit of code as it would not work for you anyway. #include <GuiConstantsEx.au3> #include <WindowsConstants.au3> #include <GUIListViewEx.au3> Local $hGUI = GUICreate("TEST", 1000, 500) Local $iOKButton = GUICtrlCreateButton("Edit", 70, 50, 60) Local $hListView = GUICtrlCreateListView("A|B|C|D|E",100,100,500,300) For $i = 1 To UBound($aTemp) - 1 GUICtrlCreateListViewItem($aTemp[$i][0] & "|" & $aTemp[$i][1] & "|" & $aTemp[$i][2] & "|" & $aTemp[$i][3] & "|"& $aTemp[$i][4], $hListView) Next $aTemp4listView=_GUIListViewEx_ReadToArray Local $hListViewEx=_GUIListViewEx_Init($hListView,$aTemp4listView,0,0,false,0+ 1+ 2 + 8+ 16+ 128+256,"4") _GUIListViewEx_MsgRegister(); required for listViewEx _GUICtrlListView_SetColumnWidth($hListView,0,0) ;hide Link code column GUISetState(@SW_SHOW, $hGUI) Local $iMsg = 0 While 1 $iMsg = GUIGetMsg() Switch $iMsg Case $iOKButton _GUIListViewEx_EditItem($hListViewEx,2,4) _GUIListViewEx_EditItem($hListViewEx,3,4) _GUIListViewEx_EditItem($hListViewEx,4,4) _GUIListViewEx_EditItem($hListViewEx,5,4) _GUIListViewEx_EditItem($hListViewEx,6,4) Case $GUI_EVENT_CLOSE ExitLoop EndSwitch _GUIListViewEx_EditOnClick() ; Required by listViewEx WEnd _GUIListViewEx_Close($hListViewEx) GUIDelete($hGUI)yet again this bit of script was used for testing so it is hardcoded. What happens is that if you actually try to edit items with use of button, it does always works for first time however after several cycles through the edit it occasionally skips the first edited line(3rd line within listview). Please note that there is a _GUIListViewEx_EditOnClick() within main loop as I need to allow user to be able to edit others if needed. As you made it so it passes true or false within extended depends on key pressed, I can test for it and stop going through predefined loop if escaped... Also predefined loop will be always executed only once and therefore this bug is irrelevant to me as only one pass which always works... Let me know if you need further info in replicating this issue. Regards Jan

Vow, I am impressed... May I just ask, do you actually have a life? Such a quick response on Saturday... Anyway thanks a lot for this, I am getting back to the original idea of using your UDF... 5 stars for your great work!!!

Also further more, it cannot simply cycle through as it might have to skip some items therefore it has to use exact coordinates during each edit item call as follow: _GUIListViewEx_EditItem($hListViewEx,1,4)_GUIListViewEx_EditItem($hListViewEx,2,4)_GUIListViewEx_EditItem($hListViewEx,4,4)_GUIListViewEx_EditItem($hListViewEx,7,4) Of course coordinates(item numbers) won't be hard-coded but calculated...

They will use barcode scanner which needs to be set to <enter> after scanned barcode due to another app it is used in... Anyway, thanks for looking into it...

Hi Melba23, I do like your work however I do have to report a more than likely a bug which is stopping me from using this UDF. I have to be able to cycle through entries in one column and where user types in the value and confirms it using enter, next item on the list becomes active for entering value(hope this make sense). Basically I cannot use arrows or tab key, I need to use <enter>. When I tried simply: _GUIListViewEx_EditItem($hListViewEx,1,4) _GUIListViewEx_EditItem($hListViewEx,2,4) _GUIListViewEx_EditItem($hListViewEx,3,4) _GUIListViewEx_EditItem($hListViewEx,4,4) _GUIListViewEx_EditItem($hListViewEx,5,4) it is doing all source of weird things if entered value confirmed by <enter>. When I add sleep in between each command it seems to partially sort it out however it keeps "selected" listview item 1 above the edit box. I thought it might be worth to report this behavior... Regards Jan