Search found 83 matches

by zotune
07 Oct 2015, 15:24
Forum: Ask For Help
Topic: Possible to reduce Excel command time?
Replies: 18
Views: 3691

Re: Possible to reduce Excel command time?

Thanks, but when you add too many items you get an error: Continuation section too long.
by zotune
07 Oct 2015, 12:43
Forum: Ask For Help
Topic: Possible to reduce Excel command time?
Replies: 18
Views: 3691

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?
by zotune
07 Oct 2015, 10:19
Forum: Ask For Help
Topic: Possible to reduce Excel command time?
Replies: 18
Views: 3691

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. ...
by zotune
30 Sep 2015, 10:45
Forum: Ask For Help
Topic: [solved] 7-zip dll in AHK
Replies: 23
Views: 8847

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.
by zotune
23 Sep 2015, 06:31
Forum: Ask For Help
Topic: [solved] 7-zip dll in AHK
Replies: 23
Views: 8847

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...
by zotune
18 Sep 2015, 09:24
Forum: Ask For Help
Topic: [solved] 7-zip dll in AHK
Replies: 23
Views: 8847

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...
by zotune
11 Sep 2015, 08:18
Forum: Ask For Help
Topic: [Solved] Get service name based on process
Replies: 2
Views: 1143

Re: Get service name based on process

trismarck: Just what I needed, thank you so much!
by zotune
11 Sep 2015, 05:19
Forum: Ask For Help
Topic: [Solved] Get service name based on process
Replies: 2
Views: 1143

[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...
by zotune
10 Sep 2015, 06:20
Forum: Scripts and Functions
Topic: [CLASS] CtlColors - color your controls (2017-10-30)
Replies: 45
Views: 20284

Re: [CLASS] CtlColors - color your controls

Okay, thanks. Even just the other two would be great. Although I know a way to do listbox.
by zotune
10 Sep 2015, 05:31
Forum: Scripts and Functions
Topic: [CLASS] CtlColors - color your controls (2017-10-30)
Replies: 45
Views: 20284

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.
by zotune
26 Jul 2015, 11:23
Forum: Ask For Help
Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Replies: 10
Views: 3862

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-26​T16:51:25.657Z

Date is correct, but year should be 2015, not 0415
by zotune
24 Jul 2015, 14:57
Forum: Wish List
Topic: Change control colors
Replies: 2
Views: 2500

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...
by zotune
24 Jul 2015, 07:38
Forum: Ask For Help
Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Replies: 10
Views: 3862

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)
by zotune
24 Jul 2015, 07:19
Forum: Ask For Help
Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Replies: 10
Views: 3862

Re: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp

Name of the file. Ticks or something created by .NET
by zotune
24 Jul 2015, 06:31
Forum: Ask For Help
Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Replies: 10
Views: 3862

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.
by zotune
24 Jul 2015, 04:05
Forum: Ask For Help
Topic: How to use the wheel to scroll the menu
Replies: 14
Views: 3904

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
by zotune
24 Jul 2015, 03:20
Forum: Ask For Help
Topic: Convert .NET DateTime ticks to AHK YYYYMMDDHH24MISS timestamp
Replies: 10
Views: 3862

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
by zotune
14 Jul 2015, 01:24
Forum: Ask For Help
Topic: Sort contents of objects in original input order
Replies: 5
Views: 1954

Re: Sort contents of objects in original input order

You can even run your own example with a second for loop.
by zotune
13 Jul 2015, 15:46
Forum: Ask For Help
Topic: Sort contents of objects in original input order
Replies: 5
Views: 1954

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
by zotune
10 Jul 2015, 05:49
Forum: Ask For Help
Topic: Sort contents of objects in original input order
Replies: 5
Views: 1954

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,...

Go to advanced search