Leaderboard

Damn! I've been working all week on a solution as per a request from Somerset, but now he won't pay me, because I missed the deadline. Wait until I work out which of his phone numbers is the correct one, then I will give him a piece of my mind.

So, I would begin by looking at GUICreate in the help file. Look at this example as a framework: #include <GUIConstantsEx.au3> $hGUI = GUICreate("Test", 300, 300) GUISetState(@SW_SHOW) While 1 Switch GUIGetMsg() Case $GUI_EVENT_CLOSE Exit EndSwitch WEnd From there I would do some reading through the help file for the controls that you would like. For example, if you would like them to type in Order1, Order2, etc., you can go with an input control: #include <GUIConstantsEx.au3> $hGUI = GUICreate("Test", 300, 300) $inpOrder = GUICtrlCreateInput("Enter your Order", 10, 10, 280, 40) $btnGo = GUICtrlCreateButton("Go", 250, 250, 40, 40) GUISetState(@SW_SHOW) While 1 Switch GUIGetMsg() Case $GUI_EVENT_CLOSE Exit Case $btnGo Switch GUICtrlRead($inpOrder) Case "Order 1" ;Call Order1 Case "Order 2" ;Call Order 2 EndSwitch EndSwitch WEnd Alternatively, you can just create a combo box for the users to choose from: #include <GUIConstantsEx.au3> $hGUI = GUICreate("Test", 300, 300) $comboOrder = GUICtrlCreateCombo("", 10, 10, 280, 25) GUICtrlSetData($comboOrder, "Order 1|Order 2|Order 3") $btnGo = GUICtrlCreateButton("Go", 250, 250, 40, 40) GUISetState(@SW_SHOW) While 1 Switch GUIGetMsg() Case $GUI_EVENT_CLOSE Exit Case $btnGo Switch GUICtrlRead($comboOrder) Case "Order 1" ;Call Order1 Case "Order 2" ;Call Order 2 EndSwitch EndSwitch WEnd That should give you some ideas. Take a spin through the help file to look at the other GUI controls, you may find something you hadn't even considered.

_ExcelReadSheetToArray is from the old version of Excel.au3: https://www.autoitscript.com/autoit3/docs/script_breaking_changes_excel_udf.htm @jloyzaga I would suggest updating to the latest version of AutoIt, which will make working with Excel much easier for you.

Sorry for the delay.

Ok so there is defiantly more than 1 way to skin a cat(not that I ever would), I do appreciate all the feedback it now lets me know that I have to read the help file 30 times over but thanks again everyone

It seems to me I know the reason. Actually the control is virtual (TVirtualStringTree) and does not contain any data. It works like an intermediary between the user interface and the application. It gets request and send it somewhere further for example to database then gets the reply from the database and put it on the screen (of course explanation looks rather primitive but it should be like this). And this is the reason that it is impossible to get something from the control. It just does not contain anything.

y'all know I've won this due to my superior coding skills and unchallenged intelligence, but relax, I'll share the bounty PS: I won't be able to do this when the price is a coffee cup.

Good to know, I'll see if I have ability to access that. Yessir

Many Thanks shai, Now is solved for me: i've looked in the forum for the error you mentioned, and found this code to check my sqlite3.dll file Got an error loading the sqlite3.dll library (perhaps because the file was from 2014) In the AutoIt Help, in the section about the funtion _SQLite_Startup: there's a link for downloading SQLite files Got the last available version (SQLite3_version.zip). unziped and changed the name to the same: sqlite3.dll

This challenge is now closed for further entries. There will be a short pause before the announcement of the winner.

I am by no means an authority on program security, but it seems to me that copyrighting it might be the way to go if you expect sufficient sales to warrant it. I believe any program or script can be decompiled. Once that's done, one could rewrite the code to point to their server and start charging $4.99, undercutting your price, and giving the same product - maybe make some change to the GUI to make it all look legit. Not that I, personally, would do that, but you get the idea. It's called intellectual property, and if you copyright it, any others that might want to use your code would have to buy a license from you (if you choose to license them.) Otherwise it's a copyright infringement, subject to you starting a lawsuit to recuperate your losses and possible punitive damages as well. Grain of salt: My "legal" advice is limited to get legal advice from a professional, again if expected sales warrant the cost. _aleph_

I have tracked this down to Windows Defender. I found my script on a Vista laptop which also uses Defender. And while I was looking at the folder containing my scripts and the compiled exes, the exes disappeared and a notification came up saying they had been quarantined. So I set the containing folder as an exception for the scan and unquarantined the files. Now investigating the Win10 machine (which has also used Defender all the time I have been running the script up to now) I see that Defender has quarantined the exe file in question, declaring it a severe threat as containing a Trojan:Win32/Pocyx.F!plock, whatever that means. I have followed the same procedure, excluding the containing folder from the scan and then restoring the exe file to it. It would appear that it is only very recently that the Defender virus signatures consider this file to be such a threat. The script is below - I think it is the right one, but it may be an early draft which I have since amended, indeed looking at it it seems to start by opening the application ("BaseStation.exe") when what in fact happens is that BaseStation.exe is already running when the Autoit exe closes it down and then re-opens it, so I suspect the same lines are used, just in a different order.. My memory is very poor these days so I cannot be exact about the history of the script. I am sure it is flawed, indeed sometimes it fails to trigger the "do you really want to close this program down?" confirmation button which is the important bit I had trouble getting to work, but mostly it works just fine. Or at least it did under Win7... I'll just have to see what happens under Win10. ; script to stop and restart BaseStation.exe every 24 hours for 20 days ; For $i = 1 to 20 ; number of days to run Run("C:\BaseStation\BaseStation.exe") Sleep(86400000) ; milliseconds in a day - exact time will drift a bit but that doesn't matter WinClose("BaseStation SBS1") WinWaitActive("Confirm", "") Send("{! down}") Send("y") Send("{! up}") ; BaseStation now takes a while to tidy up its sqlite database, save its data and close WinWaitClose ("BaseStation SBS1", "", 60) Next ; now return to normal operation in case I forget to restart manually after 20 days Run("C:\BaseStation\BaseStation.exe") WinWaitActive("BaseStation SBS1") Sleep(10000) MsgBox(4160, "SBSrestart terminated.", "This script has restarted BaseStation " & String($i) & " times." , 0) Many thanks to all who took an interest. To cover some of the points raised, we are talking about a compiled script (I mentioned it was an exe file in my first post), and I don't understand the point about 32/64 bit - the machine was 64 bit under Win 7 when the exe file ran before and it remains so under Win 10. Has Win 10 changed the rules ? Michael Hooker