Code: Select all
_ := ComObjCreate("Excel.application")
_.Visible := True
_.Workbooks.Open(myFile)
x := _.Range("A1").Value
y := _.Sheets(1).Range("A1").Value
MsgBox, % x "`n" ySearch found 176 matches
- 16 Apr 2019, 03:01
- Forum: Ask for Help (v1)
- Topic: Excel COM Range suddenly stopped working
- Replies: 6
- Views: 1607
Re: Excel COM Range suddenly stopped working
I had no errors here, works fine with both cases
- 15 Apr 2019, 05:04
- Forum: Ask for Help (v1)
- Topic: How to chang a string to integer Topic is solved
- Replies: 14
- Views: 2258
Re: How to chang a string to integer Topic is solved
you post a question
you checked your question as an answer.. very nice..
you checked your question as an answer.. very nice..
- 15 Apr 2019, 03:08
- Forum: Ask for Help (v1)
- Topic: SOLVED : remapped f10-to-mute key only works if I hold down another function key
- Replies: 8
- Views: 1764
Re: remapped f10-to-mute key only works if I hold down another function key
ah.. following codes too, for sure
Code: Select all
F10:: MsgBox F10
F11:: MsgBox F11
F12:: MsgBox F12- 15 Apr 2019, 03:05
- Forum: Ask for Help (v1)
- Topic: SOLVED : remapped f10-to-mute key only works if I hold down another function key
- Replies: 8
- Views: 1764
Re: remapped f10-to-mute key only works if I hold down another function key
what do you mean 'stopped working' precisely
one suggestion
make a new/clean .ahk file
just make the 3 key remapping you wanted only, nothing else even no other .ahk files running
and test it again
one suggestion
make a new/clean .ahk file
just make the 3 key remapping you wanted only, nothing else even no other .ahk files running
and test it again
- 15 Apr 2019, 02:23
- Forum: Ask for Help (v1)
- Topic: Array sorting Topic is solved
- Replies: 2
- Views: 1003
Re: Array sorting Topic is solved
use Dictionary
-case Sensitive
-no Automatic sorting
-case Sensitive
-no Automatic sorting
Code: Select all
_ := ComObjCreate("Scripting.Dictionary")
_.Item("Yellow") := "First"
_.Item("Black") := "Second"
_.Item("Green") := "Third"
For k In _
r .= k ", " _.Item(k) "`n"
MsgBox % r- 15 Apr 2019, 01:20
- Forum: Ask for Help (v1)
- Topic: [SOLVED] How can a unicode ligature character be found and replaced with a script? Topic is solved
- Replies: 34
- Views: 5964
- 15 Apr 2019, 01:15
- Forum: Ask for Help (v1)
- Topic: [SOLVED] How can a unicode ligature character be found and replaced with a script? Topic is solved
- Replies: 34
- Views: 5964
- 15 Apr 2019, 00:37
- Forum: Ask for Help (v1)
- Topic: [SOLVED] How can a unicode ligature character be found and replaced with a script? Topic is solved
- Replies: 34
- Views: 5964
- 14 Apr 2019, 21:38
- Forum: Ask for Help (v1)
- Topic: Number Sorting - Improper Array Sort Topic is solved
- Replies: 8
- Views: 2864
Re: Number Sorting - Improper Array Sort Topic is solved
the real meaning of Elementary is..
at least it has to sort its own members, basically
but, it sort only a list of elementary text
for instance, it is totally blind to array (any kind pseudo or simple)
I even do not mention the famous 'Object' in this place
that is what I meant Elementary
at least it has to sort its own members, basically
but, it sort only a list of elementary text
for instance, it is totally blind to array (any kind pseudo or simple)
I even do not mention the famous 'Object' in this place
that is what I meant Elementary
- 14 Apr 2019, 21:05
- Forum: Ask for Help (v1)
- Topic: Number Sorting - Improper Array Sort Topic is solved
- Replies: 8
- Views: 2864
Re: Number Sorting - Improper Array Sort Topic is solved
AHK has a built in function, of course
Have a fun with it first is not so bad idea
Elementary functionality though
Have a fun with it first is not so bad idea
Code: Select all
myBefore := "9 7 3 1 2 8 4 5 6"
myTemp := RegExReplace(myBefore, " ", "`n")
Sort, myTemp
myAfter := RegExReplace(myTemp, "`n", " ")
MsgBox % ""
. myBefore "`n"
. myAfter- 14 Apr 2019, 05:16
- Forum: Ask for Help (v1)
- Topic: ActiveCell.value+1 not worked if cell is date.
- Replies: 3
- Views: 933
Re: ActiveCell.value+1 not worked if cell is date.
How about to use CDate function of VBA ? though I have never used it at AHK
- 14 Apr 2019, 04:41
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
@just me
First of all, your code is the same kind, already posted.
Lastly, I am feeling that it is time for me to quit this post
Sorry, I am not going to make any further post
regards
First of all, your code is the same kind, already posted.
Lastly, I am feeling that it is time for me to quit this post
Sorry, I am not going to make any further post
regards
- 14 Apr 2019, 04:37
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
SOTE Agree !! Nice comment I really like this kind of stuffs It reminds me some previous unpleasant experience, when I add a comment at AHK_SQLite place. Up until now, I do not have any intention to learn C/C++ to use SQLite in AHK regards AutoHotkey is fantastic for newbies, casuals, non-programme...
- 14 Apr 2019, 03:44
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
@toralf
Talk is cheap, show me the codes Linus Benedict Torvalds
Talk is cheap, show me the codes Linus Benedict Torvalds
- 14 Apr 2019, 02:12
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
In this brief post I could learn followings You do not have to think it deeply, which one you are using between for loop and foreach loop in C# . Because they have almost identical speed in real world. Coding is not painful but happy. You have to think it deeply, which one you are using between For ...
- 13 Apr 2019, 20:47
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
when I tested this issue with another language it gives me somewhat different from AHK for instance C#. There is no meaningful differencies between them, I mean one is using Enumerator the other is not (Unfortunately, I do not know detailed algorithm though) var s = new Stopwatch(); int iteration = ...
- 13 Apr 2019, 20:33
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
If AHK's Q/A policy is just answer the question strictly and shut your mouth,, yes I am a crazy one. As you can see, I am testing somewhat related items with the main issue(s). I guess, that is not so bad activity here. My last comment is saying/proving This topic revolves around a very limited and ...
- 13 Apr 2019, 20:19
- Forum: Ask for Help (v1)
- Topic: Participating in Stanford University research in web automation!
- Replies: 7
- Views: 1564
Re: Participating in Stanford University research in web automation!
I do not know what you mean specifically "web automation" but I am using AHK to handle human language (text translation) mainly. -visit search engines like Google and local portal etc. Via IE COM style -translate some brief sentence(s) from English to another language(again Google free of charge ser...
- 13 Apr 2019, 11:10
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
in Real world you have to confront with enemies somewhat different from nice theory Loop loop is incredibly faster than For loop i := 1000000 ; a million x := "A.B.C" s := A_TickCount Loop, % i For Each, y In StrSplit(x, ".") ; 719 Ticks continue firstResult := A_TickCount - s s := A_TickCount Loop,...
- 13 Apr 2019, 06:05
- Forum: Ask for Help (v1)
- Topic: Which is the best way to enumerate array elements? Topic is solved
- Replies: 35
- Views: 7152
Re: Which is the best way to enumerate array elements? Topic is solved
amazing.. My point is this post is pointless . When the Loop loop was designed there was NO arrays in AHK Further, Loop loop is general purpose command not for the purpose of simple iteration. -Can you use For loop to iterate files/folders ? Loop loop is just like steel toed safety shoes. You can us...