Jump to content

All Activity

This stream auto-updates     

  1. Past hour
  2. So I came to work today with a bit of an issue... I forgot to bring my mouse. I have a laptop as my secondary computer, but the desktop has some legacy applications I need to use everyday. The legacy apps don't have keyboard shortcuts, and navigation without a mouse could be impossible (trust me, I've tried). So I got busy and put together this script. The script includes basic mouse movement, clicking, and a text editing mode (mouse movement is disabled). I threw it together quickly, and haven't done too much testing, but it is SUPER helpful already. Let me know if anyone is interested, and I'll keep this updated and/or add features as requested I hope to implement a Tray menu with a GUI and some directions later (Like what keyboard shortcuts do), but what I have works for now. Shortcut List: Arrow Key - move the mouse in the indicated direction 30 pixels Ctrl + Arrow Key - move the mouse in the indicated direction 100 pixels Ctrl + Shift + Arrow Key - move the mouse in the indicated direction 3 pixels Ctrl + Space - Left click Ctrl + Shift + Space - Right click (because sometimes that special right-click-button doesn't work) Alt + F8 - Toggle mouse movement for text editing / other Alt + F9 - Quit (Version source and executable attached) KeyboardMouse.au3 KeyboardMouse.exe
  3. Today
  4. When you post multiple threads which are locked, open another account and start again, yet still get a second chance from the Moderation team it seems silly to then open a further thread insulting us and the community as a whole. We have rules in this forum and if you want to be a part of the community then you need to respect them - as you appear to have no intention of doing that your account is banned. M23
  5. Got it sorted !!!!!!!!!!!!!!! 🙂 I ran the ".au3" script and got the error message. However, I then went into Task Manager and clicked on the Autoit3.exe process. Then I selected "Open File Location". It was running an old version of Autoit3 located within a folder (it was for a small portable app that I created for my memory stick). I deleted that version and when I ran the script again it worked!!!! Really weird as the default pointed to the Programs(x86) folder, and I also tried the "open with" menu option (and navigated to the Programs(x86) folder). Anyway, it is all working again 🙂 Many thanks for all your help. Hopefully, one day I will be as knowledgable as you guys 🙂 Best regards, Pete
  6. Hi Jos, I un-installed it again, downloaded a fresh version and re-installed it in Programs(x86). Still no luck. SciTE still works ok. I did however, navigate to the AutoIt3 folder and ran the Autoit3_x64.exe from there. When it prompted me for the ".au3" file to open I picked the script and it ran ok (?) Therefore, double-clicking on an ".au3" script seems to fail, but openning either SciTE or running Autoit3_x64.exe works!!! The Registry entries are still the same as above. Kind regards, Pete
  7. So you have a standard directory structure in program files(x86)\AutoIt\includes and it contains all files? Any security settings issue or something? Try running SciTE as Admin and test again, just to see if that changes anything. Jos
  8. Hi Jos... Yes. I downloaded the latest version from the official site and used the installer to install it. 🙂
  9. Hmmm, I don't have AutoUpdateIt, but I do have AU3Info, Aut2Exe and AutoIt. Look like you have some bad install, but I cannot be sure. Maybe someone else could help...
  10. Have you used the installer to install AutoIt3? Jos
  11. Hi Nine, many thanks for your quick response. 🙂 I don't have that entry. All I have is: HKEY_CURRENT_USER\Software\AutoIt v3\Aut2Exe HKEY_CURRENT_USER\Software\AutoIt v3\AutoUpdateIt
  12. Could you look at this key in regedit : HKEY_CURRENT_USER\Software\AutoIt v3\AutoIt - Include ?
  13. Hi Guys, Apparently the problem is "Citrix" as it uses a cut-down version of IE6 as an interface, which excludes certain functionality. AutoIT sends the correct command to Citrix, but as the IE6 has been stripped down it doesn't include that functionality any more. The workaround is to use send({LWINDOWN}{UP}{LWINUP}) which does the trick. Thanks to everyone who helped. Hopefully one day I will as knowledgable as you peeps 🙂
  14. Hi guys, I am still learning the ropes, so apologies if I have missed something obvious. Basically, the #include statement is not working for me (not even when I include the full pathname) e.g. #include <Date.au3> MsgBox(0,'',"The time is:" & _NowTime()) The above example returns the following error; #include <Date.au3> Error opening the file I tried removing/reinstalling Autoit3, but to no avail. I have tried installing AutoIt3 firstly in Programs & then when that didn't work, I un-installed it again and re-installed it in Programs(x86). Have also tried using both AutoIt3.exe and AutoIt3_x64.exe versions, but each time it is the same error. The only way that the above script (or any script) works is if I run it from within SciTE. Has anyone else encountered such problems? Many thanks, Pete
  15. I am curious if this code could work on 300,000 rows. I have Excell 2003, so I am limited to 65k rows. But the result is quite fast. Maybe you could try it : #include <Excel.au3> #include <MsgBoxConstants.au3> Local $oExcel = _Excel_Open() If @error Then Exit MsgBox($MB_SYSTEMMODAL, "", "Error creating the Excel application object.") Local $oWorkbook = _Excel_BookOpen($oExcel, "65000.xls") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "", "Error opening Workbook") _Excel_RangeSort($oWorkbook, Default, Default, "A:A") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "", "Error sorting data.") Local $iPrev = 1 Local $aResult = _Excel_RangeRead($oWorkbook, Default, "A:A") For $i = 2 to 10 $iFound = _ArraySearch ($aResult,$i,$iPrev-1,0,0,0,1,0) MakeCopy ($iPrev, $iFound, @ScriptDir & "\T" & $i-1 & ".xls") $iPrev = $iFound+1 Next MakeCopy ($iPrev, UBound ($aResult), @ScriptDir & "\T10.xls") Func MakeCopy ($iStart, $iEnd, $sName) Local $oRange = $oWorkbook.ActiveSheet.Range("A" & $iStart & ":N" & $iEnd) Local $oWB = _Excel_BookNew ($oExcel, 1) _Excel_RangeCopyPaste($oWB.ActiveSheet, $oRange, "A1") If @error Then Exit MsgBox($MB_SYSTEMMODAL, "", "Error copying cells." & "/" & @error) _Excel_BookSaveAs($oWB, $sName, $xlWorkbookNormal, True) If @error Then Exit MsgBox($MB_SYSTEMMODAL, "", "Error saving as" & "/" & @error) _Excel_BookClose ($oWB,False) EndFunc
  16. Sorry but I don't understand what you mean by " use Autoit's sql commands on top ". You just query the SQLite database with the SQLite.au3 UDF. Again if your source Excel file will change, the DB must be changed accordingly, so going thru SQLite isn't beneficial (details may muddy the border). But if the Excel file is given once for all, you can most probably benefit from the power of SQLite queries, including add-on functions if necessary. For instance, recent SQLite versions offer windowing features, full text table search (legacy feature), and a lot more. It all depends on the needs you have and the complexity of your queries. The nice thing is that SQLite doesn't need any installation nor maintenance, contrary to "heavy" client-server DB engines.
  17. Once its accessed via ADO, and extract it into a SQLite DB (as jchd said), would you then use Autoit's sql commands on top, or would you just access it via a SQLite and use sql commands?
  18. Macro BlockInput(bool) BlockInput_(bool) EndMacro BlockInput(1) Delay(3000) BlockInput(0) I fixed two functions. There it is not possible to get the size of the field to return data. Procedure.s DriveGetLabel(Drive$) Protected Label$ Label$=Space(#MAX_PATH+1) If Not GetVolumeInformation_(Drive$,Label$,#MAX_PATH+1,0,0,0,0,0) Procedure_Error = 1 ProcedureReturn "" EndIf ProcedureReturn Label$ EndProcedure MessageRequester("Disk label", DriveGetLabel("C:\")) Procedure.s DriveGetFileSystem(Drive$) Protected FileSystem$ FileSystem$=Space(#MAX_PATH+1) If GetVolumeInformation_(Drive$,0,0,0,0,0,@FileSystem$,#MAX_PATH+1) ProcedureReturn FileSystem$ Else Procedure_Error = 1 ProcedureReturn "1" EndIf EndProcedure MessageRequester("File system type", DriveGetFileSystem("C:\"))
  19. @jdelaney I'm traveling now and when I go back I'll do the tests, thanks for the tips.
  20. Updating the code I will try to simplify as much as possible the last functions
  21. What's New in Version 0.2019.04.19 fixed: GetProcessTimes() crashing on multi-user setup The code is in the downloads area.
  22. Internet search engine use https://docs.microsoft.com/en-us/windows/desktop/api/fileapi/nf-fileapi-getdrivetypea DRIVE_UNKNOWN = 0
  23. @AZJIO Hello friend the first example requires a correction ( Line 83:Constant not found : #DRIVE_UNKNOWN ) thank you
  24. Epicface, FrancescoDiMuro is quite right - please read the Forum rules - particularly the bit about not discussing game automation - before you post again. Thread locked. But welcome to the AutoIt forum - and see you soon with a legitimate question I hope. M23
  25. The good sense to read forum rules, since game automation is not allowed on these forums.
  26. If that's OK then you can get rid of the first column, since it's just a redundant decoration of the row number, i.e. the index thru the array. That will simplify code some more. If you want to save the simplified array while adding the "name #" prefix, you can do that while going thru the array for output. Also I still don't understand what you meant whith "A1Peter...": the A1, B2 C3 prefixes jump in your post but have no materialization in the code sample you supplied. That's why I ignored that sentence.
  1. Load more activity
  • Create New...