Search found 411 matches

by IMEime
07 Jul 2017, 12:31
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

Some ideas (if anyone has any other RegEx ideas or good links for RegEx and splitting paths, please share):... humble one of mine MsgBox % RegExReplace( A_ScriptFullPath, ".*\K\\.*") I do not want to be cofused with given/fixed/hidden function. so i prefer to use RegEx, it is so clear.. a...
by IMEime
07 Jul 2017, 11:03
Forum: Ask For Help
Topic: Excel VBA: UCase and LCase
Replies: 13
Views: 874

Re: Excel VBA: UCase and LCase

not much

thinking dll or something
but, time is precious


^^
if you have leisure time,
do it with Haskel or Erlang within AHK..
oh sounds good.
really good.


regards
by IMEime
07 Jul 2017, 03:11
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

Guest wrote:...I typically wrap everything in a function or class anyway so the "ghost" goes away when the function returns and clears its local variables.

I do not think so.
Can you please show me a brief example of you say "ghost_free_warp" ones ?
Sounds interesting..
by IMEime
07 Jul 2017, 03:05
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

Oh my god !! This is totally awesome !! It only takes about 45 seconds to process about 4000 lines in the original file ! With my old script it took about 20-30 minutes !!.... That looks like your own homework. The guy "kon" has already made the best lecture in this place. Find and study....
by IMEime
07 Jul 2017, 02:52
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

Don't know VBA or COM either, but if you can work with CSV... So, what happens when you read the CSV you modified ? The excel comes up ? Yes, the CSV extension is associated with Excel so you can open it directly. Of course formulas and formatting (bold, colours) will be lost but it all depends on ...
by IMEime
06 Jul 2017, 23:06
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

Guest wrote:Don't know VBA or COM either, but if you can work with CSV...

So, what happens when you read the CSV you modified ?
The excel comes up ?
by IMEime
06 Jul 2017, 22:57
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

kon wrote:....

Well, it is a good code, especially for beginner.
But, You have to know one point.
After you finished above code.
You have its remainder.
In my case, I do not want to have it.
Check it out with CtlAltDel.
The Excel ghost !!!!

Enjoy AHK
by IMEime
06 Jul 2017, 08:57
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

EDIT: Come on IMEime, you have already been warned to behave. Play nice. woooo send command is only and sole friend of you as you mentioned it is time to make a new friend ( COM ) this one is good of course, COM is a F.a.k.e. you have to familiar with VBA for Excel, this is the real one fin...
by IMEime
06 Jul 2017, 03:44
Forum: Ask For Help
Topic: Change text selection behavior
Replies: 3
Views: 210

Re: Change text selection behavior

welcome aboard

where is your code ?
by IMEime
06 Jul 2017, 02:14
Forum: Ask For Help
Topic: Split excel file in many small ones
Replies: 61
Views: 3823

Re: Split excel file in many small ones

EDIT: Come on IMEime, you have already been warned to behave. Play nice. woooo send command is only and sole friend of you as you mentioned it is time to make a new friend ( COM ) this one is good of course, COM is a F.a.k.e. you have to familiar with VBA for Excel, this is the real one fin...
by IMEime
05 Jul 2017, 20:03
Forum: Ask For Help
Topic: How to mouse wheeldown less than 1 unit
Replies: 5
Views: 625

Re: How to mouse wheeldown less than 1 unit

jeeswg wrote:I'd been curious to know about how...
I was wondering how you guys find something very well.
Now I see some of it (I've nerver thouched its source code, because I do not know C++).

Good job.
by IMEime
05 Jul 2017, 11:24
Forum: Ask For Help
Topic: ComObjGet problem Topic is solved
Replies: 9
Views: 623

Re: ComObjGet problem Topic is solved

one asked about doc one answerd with xls is it right ? i do not know (in some points, MS excle has the same aspect with MS word. But mostly both of them are different.) i tried all kind of ways before i post question or help. from time to time i found the answer by myself if nobody commented it I de...
by IMEime
05 Jul 2017, 10:04
Forum: Ask For Help
Topic: Out putting date and time without colon?
Replies: 7
Views: 404

Re: Out putting date and time without colon?

i'm not much follower of FormatTime function
that is not so simple to use
by IMEime
05 Jul 2017, 09:26
Forum: Ask For Help
Topic: Out putting date and time without colon?
Replies: 7
Views: 404

Re: Out putting date and time without colon?

MsgBox % "" . A_Now "`n" . A_YYYY "`n" . A_MM "`n" . A_MMM "`n" . A_MMMM "`n" . A_DD "`n" . A_DDD "`n" . A_DDDD "`n" . A_Hour "`n" . A_Min "`n" . A_Sec "`n" . A_NowUTC "`n&qu...
by IMEime
05 Jul 2017, 04:04
Forum: Ask For Help
Topic: ComObjGet problem Topic is solved
Replies: 9
Views: 623

Re: ComObjGet problem Topic is solved

if you want to know WHY
you have to go back way more than 20 years of the MS history
forget about it
just find a way for yourself
by IMEime
05 Jul 2017, 03:53
Forum: Ask For Help
Topic: ComObjGet problem Topic is solved
Replies: 9
Views: 623

Re: ComObjGet problem Topic is solved

I do not know all the circumstances of yours though,
https://autohotkey.com/boards/viewtopic ... 68#p155668

good luck
by IMEime
03 Jul 2017, 08:09
Forum: Ask For Help
Topic: Getting length and content of selection in MS Word Topic is solved
Replies: 7
Views: 540

Re: Getting length and content of selection in MS Word Topic is solved

There are no NULL text in MS Word. There are no differences between Range and Select in this case. ignorant is bliss if you do not select anything and you are at the end of sentence it grabs the paragraph mark that is a Select the MS made, you have to remember it a paragraph mark is not a NULL at a...
by IMEime
03 Jul 2017, 04:21
Forum: Ask For Help
Topic: Getting length and content of selection in MS Word Topic is solved
Replies: 7
Views: 540

Re: Getting length and content of selection in MS Word Topic is solved

There are no NULL text in MS Word.
There are no differences between Range and Select in this case.
by IMEime
30 Jun 2017, 10:46
Forum: Ask For Help
Topic: Loop, parse a paragraph
Replies: 9
Views: 605

Re: Loop, parse a paragraph

this one is good to start just like you
https://autohotkey.com/boards/viewtopic.php?f=7&t=8978


COM (Word VBA) has its own Paragraph collection.

Document.Paragraphs Property
https://msdn.microsoft.com/en-us/VBA/wo ... perty-word

Go to advanced search