| Author |
Message |
Topic: Basic Ahk_L COM Tutorial for Excel |
Andi
Replies: 83
Views: 5218
|
Forum: General Chat Posted: Fri Oct 07, 2011 7:43 am Subject: Basic Ahk_L COM Tutorial for Excel |
Thank you Mickers for your help.
Instead of using ".select", for me the ".row"-method shows what I need:
NextFreeRow := objExcel.Worksheets(1).Cells(1, &q ... |
Topic: Basic Ahk_L COM Tutorial for Excel |
Andi
Replies: 83
Views: 5218
|
Forum: General Chat Posted: Mon Oct 03, 2011 9:11 pm Subject: Basic Ahk_L COM Tutorial for Excel |
how to detect the next free row for writing new input?
The approach with ...End(xlUp.Row)... doesnt work. Any idea whats wrong here?
WorkBookPath = C:\Program Files\AutoHotkey\Sample ... |
Topic: ADODB Excel Database Query [AHK_L] |
Andi
Replies: 8
Views: 2412
|
Forum: Scripts & Functions Posted: Wed Jan 26, 2011 3:29 am Subject: ADODB Excel Database Query [AHK_L] |
The ahk-help says:` (literal accent; i.e. two consecutive escape characters result in a single literal character)
I tried shajul's first version, and for me this code does the job in the same way. ... |
Topic: ADODB Excel Database Query [AHK_L] |
Andi
Replies: 8
Views: 2412
|
Forum: Scripts & Functions Posted: Thu Dec 23, 2010 3:52 am Subject: ADODB Excel Database Query [AHK_L] |
very interesting
...but the script crashes with the colums OrderDate, Units, Unit Cost and Total. Whats wrong here?
---------------------------
B0582697.ahk
---------------------------
... |
Topic: RegExMatch: How to find a filesuffix in a wintitle |
Andi
Replies: 7
Views: 270
|
Forum: Ask for Help Posted: Tue Mar 23, 2010 5:01 am Subject: RegExMatch: How to find a filesuffix in a wintitle |
Now that's much more clearer to me. Thank you! |
Topic: RegExMatch: How to find a filesuffix in a wintitle |
Andi
Replies: 7
Views: 270
|
Forum: Ask for Help Posted: Mon Mar 22, 2010 4:23 pm Subject: RegExMatch: How to find a filesuffix in a wintitle |
Thank you for your answers
@guest: -3 doesn't work
@answer4u: What a wonderful solution!! It works like a charm!!
With the following code I'm able to get also an extension with four cha ... |
Topic: RegExMatch: How to find a filesuffix in a wintitle |
Andi
Replies: 7
Views: 270
|
Forum: Ask for Help Posted: Mon Mar 22, 2010 3:28 pm Subject: RegExMatch: How to find a filesuffix in a wintitle |
Hi,
I'm trying to retrieve the suffix from a windowstitle with RegExMatch.
For example the title is: "Lucie Diamond.doc .tif If StartingPosition is less than 1, it is considered to be an off ... |
Topic: Need help in this error |
Andi
Replies: 2
Views: 351
|
Forum: Ask for Help Posted: Fri Mar 05, 2010 12:08 pm Subject: Need help in this error |
Try to release COM.
Has someone perhaps a solution for ahk to avoid the Outlook security check?
See also here
http://msdn.microsoft.com/de-de/library/aa168346(en-us,office.11).aspx
... |
Topic: Help with optimizing ImageSearch loop |
Andi
Replies: 3
Views: 453
|
Forum: Ask for Help Posted: Fri Jul 17, 2009 8:26 am Subject: Help with optimizing ImageSearch loop |
to reduce the heavy CPU load, you may insert a sleep command in every loop... perhaps sleep 200  |
Topic: Retrieve the name of a control by coordinates |
Andi
Replies: 3
Views: 400
|
Forum: Ask for Help Posted: Sun May 17, 2009 6:03 am Subject: Retrieve the name of a control by coordinates |
@DControl:
I want to read the subject field of an e-mail program (Lotus Notes)
Unfortunaly, the name of the control changes it's name from one msg to another.
@almin:
Thank you, this seems to be ... |
Topic: Retrieve the name of a control by coordinates |
Andi
Replies: 3
Views: 400
|
Forum: Ask for Help Posted: Fri May 15, 2009 10:02 am Subject: Retrieve the name of a control by coordinates |
Hi,
is there a way to retrieve the name of control directly?
... or must I first to move the mouse and in step 2 using the mouseGetPos command?
I've got the x,y screen coordinates of the contro ... |
Topic: SAP R/3 Scripting with AutoHotkey |
Andi
Replies: 10
Views: 3053
|
Forum: Ask for Help Posted: Fri Apr 10, 2009 9:00 pm Subject: SAP R/3 Scripting with AutoHotkey |
Thank you, for your replies. I also think, that it would be valuable to get in hand with COM...
@Non-SAP-Fan,
you may try to solve this problem in making use of the command SetTitleMatchMode, 2. T ... |
Topic: IfWinExist/Active /() reports false for active window |
Andi
Replies: 24
Views: 4905
|
Forum: Bug Reports Posted: Thu Apr 09, 2009 1:38 am Subject: IfWinExist/Active /() reports false for active window |
| the best thing would be, when you post your code... |
Topic: pixelsearch different colors |
Andi
Replies: 6
Views: 402
|
Forum: Ask for Help Posted: Mon Mar 09, 2009 8:34 pm Subject: pixelsearch different colors |
would it be a workaround, when you just search two times? So when then first search fails you begin starting a second search with a different color that may match better  |
Topic: SAP R/3 Scripting with AutoHotkey |
Andi
Replies: 10
Views: 3053
|
Forum: Ask for Help Posted: Sun Mar 08, 2009 10:51 am Subject: SAP R/3 Scripting with AutoHotkey |
Hi,
I'm using AutoHotkey since several years at work, to automate processes with our SAP R/3 system.
This works very well, but I think it would be easier and more reliable to talk to the SAP GUI d ... |
| |