Search found 83 matches
- 07 Oct 2015, 15:24
- Forum: Ask For Help
- Topic: Possible to reduce Excel command time?
- Replies: 18
- Views: 3728
Re: Possible to reduce Excel command time?
Thanks, but when you add too many items you get an error: Continuation section too long.
- 07 Oct 2015, 12:43
- Forum: Ask For Help
- Topic: Possible to reduce Excel command time?
- Replies: 18
- Views: 3728
Re: Possible to reduce Excel command time?
Thanks, I figured someone would give that last example. I'm aware of that, but I color log items based on its contents, so I can't really do a range for most things. I need to do individual colors for a lot of items.
Is there no faster way to do this?
Is there no faster way to do this?
- 07 Oct 2015, 10:19
- Forum: Ask For Help
- Topic: Possible to reduce Excel command time?
- Replies: 18
- Views: 3728
Possible to reduce Excel command time?
Logfiles with 10000 lines take almost 3 minutes xl := ComObjCreate("Excel.Application") xl.WorkBooks.Add xl.Visible := false StartTime := A_TickCount Loop, 100 { xl.Range("A" A_Index).Interior.Color := 6015990 } ElapsedTime := A_TickCount - StartTime MsgBox, %ElapsedTime% milliseconds have elapsed. ...
- 30 Sep 2015, 10:45
- Forum: Ask For Help
- Topic: [solved] 7-zip dll in AHK
- Replies: 23
- Views: 9008
Re: [solved] 7-zip dll in AHK
Bump! Anyone got 7zip-64.dll working? I'm sure it's not a major difference, although I'm curious.
- 23 Sep 2015, 06:31
- Forum: Ask For Help
- Topic: [solved] 7-zip dll in AHK
- Replies: 23
- Views: 9008
Re: [solved] 7-zip dll in AHK
Thanks Masonjar Couple of things, only A_PtrSize=8 works for me to determine if I have a 64bit system I'm not sure I understand the point of this: if(!fileExist(lib)){ } Extracting archive with 7zip-32.dll works, but not 7zip-64.dll, even if I fix A_PtrSize. What gives? (using this version: http://h...
- 18 Sep 2015, 09:24
- Forum: Ask For Help
- Topic: [solved] 7-zip dll in AHK
- Replies: 23
- Views: 9008
Re: [solved] 7-zip dll in AHK
Try this: #SingleInstance Force #Persistent SetBatchLines -1 Process,Priority,,H global sevProc:=dllCall("GetProcAddress","Ptr",dllCall("LoadLibrary","Str","7-zip64.dll","Ptr"),"AStr","SevenZip","Ptr") cnt:=100,file:="test.7z",timing:=a_tickcount Loop % cnt dllCall(sevProc, "Ptr", A_ScriptHwnd,"ASt...
- 11 Sep 2015, 08:18
- Forum: Ask For Help
- Topic: [Solved] Get service name based on process
- Replies: 2
- Views: 1160
Re: Get service name based on process
trismarck: Just what I needed, thank you so much!
- 11 Sep 2015, 05:19
- Forum: Ask For Help
- Topic: [Solved] Get service name based on process
- Replies: 2
- Views: 1160
[Solved] Get service name based on process
Is there a fast way to get service name based on process? I have a kill function that I want to use for services too, it says that if a program is running in a certain folder, then kill it, however this won't work for services. And I need to disable them, then re-enable them (when set to run) for th...
- 10 Sep 2015, 06:20
- Forum: Scripts and Functions
- Topic: [CLASS] CtlColors - color your controls (2017-10-30)
- Replies: 45
- Views: 20998
Re: [CLASS] CtlColors - color your controls
Okay, thanks. Even just the other two would be great. Although I know a way to do listbox.
- 10 Sep 2015, 05:31
- Forum: Scripts and Functions
- Topic: [CLASS] CtlColors - color your controls (2017-10-30)
- Replies: 45
- Views: 20998
Re: [CLASS] CtlColors - color your controls
This is my favorite ahk library. Thanks for making this.
Any chance you'd be willing to implement highlight colors for Edit, Listbox, and possibly Treeview?
I only know a way to do listbox atm.
Any chance you'd be willing to implement highlight colors for Edit, Listbox, and possibly Treeview?
I only know a way to do listbox atm.
- 26 Jul 2015, 11:23
- Forum: Ask For Help
- Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
- Replies: 10
- Views: 3904
Re: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Blackholyman, this site does the conversion somewhat correctly: http://tickstodatetime.com/
Tick (from filename): 130824030856564401
File created time (from windows): 26.07.2015 18:51
TicksToDatetime: 0415-07-26T16:51:25.657Z
Date is correct, but year should be 2015, not 0415
Tick (from filename): 130824030856564401
File created time (from windows): 26.07.2015 18:51
TicksToDatetime: 0415-07-26T16:51:25.657Z
Date is correct, but year should be 2015, not 0415
- 24 Jul 2015, 14:57
- Forum: Wish List
- Topic: Change control colors
- Replies: 2
- Views: 2563
Change control colors
Currently I'm using ControlCol for a lot of it, but I would really like to have it internally in AHK since it is 32bit only. Just setting front and background color on stuff would go a long way. I can use GUI, Add, Text to make custom background colors. Besides, ControlCol crashes resize. http://www...
- 24 Jul 2015, 07:38
- Forum: Ask For Help
- Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
- Replies: 10
- Views: 3904
Re: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
File looks like this SHOW.TEST_130814384725063210.xml
Numbers are supposed to provide a date based on ticks from 1970 or something (.NET)
Numbers are supposed to provide a date based on ticks from 1970 or something (.NET)
- 24 Jul 2015, 07:19
- Forum: Ask For Help
- Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
- Replies: 10
- Views: 3904
Re: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Name of the file. Ticks or something created by .NET
- 24 Jul 2015, 06:31
- Forum: Ask For Help
- Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
- Replies: 10
- Views: 3904
Re: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
I'm not even sure where that 0415 comes from, should be this year. Maybe [DateTime] doesn't work properly either.
IE: 130822047195938865, should be 24 June 2015 11:45
Currently I base it on File created time, but I figure if someone copy these files around, then that will break it.
IE: 130822047195938865, should be 24 June 2015 11:45
Currently I base it on File created time, but I figure if someone copy these files around, then that will break it.
- 24 Jul 2015, 04:05
- Forum: Ask For Help
- Topic: How to use the wheel to scroll the menu
- Replies: 14
- Views: 3946
Re: How to use the wheel to scroll the menu
Something like this might work 

Code: Select all
GUI +HWNDwindowname ;Put this before your GUI
#If WinActive("ahk_id " windowname) ;Put all of this at the end of your script
WheelDown::
Send, {Down}
Return
WheelUp::
Send, {Up}
Return
- 24 Jul 2015, 03:20
- Forum: Ask For Help
- Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
- Replies: 10
- Views: 3904
Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Here's an example: 130814384725063210
If you type [Datetime]130814384725063210 into powershell it returns the date. Anyone know how to convert this information in AHK?
Appreciate any help
Mikael
If you type [Datetime]130814384725063210 into powershell it returns the date. Anyone know how to convert this information in AHK?
Appreciate any help

Mikael
- 14 Jul 2015, 01:24
- Forum: Ask For Help
- Topic: Sort contents of objects in original input order
- Replies: 5
- Views: 1990
Re: Sort contents of objects in original input order
You can even run your own example with a second for loop.
- 13 Jul 2015, 15:46
- Forum: Ask For Help
- Topic: Sort contents of objects in original input order
- Replies: 5
- Views: 1990
Re: Sort contents of objects in original input order
Neuromancer: Thanks, although. I'm having a problem with this, it won't return the second msgbox (first for loop empties it). Any idea why?
https://bpaste.net/show/0fd0b95149b7
https://bpaste.net/show/0fd0b95149b7
- 10 Jul 2015, 05:49
- Forum: Ask For Help
- Topic: Sort contents of objects in original input order
- Replies: 5
- Views: 1990
Sort contents of objects in original input order
Apps:={} Apps["Manus"] := {Name: "MMConsoleAdmin", Checkbox: 0, Process: "MMConsoleAdmin_2007.exe", Registry: "Server"} Apps["Media"] := {Name: "MMMediaAdministrator", Checkbox: 0, Process: "MMMediaAdministrator.exe", Registry: "Server"} Apps["AVAutomation"] := {Name: "MMAVAutomation", Checkbox: 0,...