Search found 16 matches
- 25 Sep 2019, 15:06
- Forum: Ask for Help (v1)
- Topic: Active window position and size change Topic is solved
- Replies: 9
- Views: 1199
Re: Active window position and size change Topic is solved
What I noticed too is that when original position of the active window is on my left monitor, then I run the above code: While it does move the active window to the right screen, per those coordinates, if I then minimize that window, than maximize - it does not maximize to it's new position on the r...
- 17 Sep 2019, 15:02
- Forum: Other Utilities & Resources
- Topic: Balance Sheet, Final Accounts, Accounting
- Replies: 5
- Views: 9896
Re: Balance Sheet, Final Accounts, Accounting
Would be nice a link to a YouTube video demonstrating / explaining this script in action Looks like maybe it presents user with some GUI (you think?!) for input and in the end summarizes those inputs? What if anything it replaces though, what need does this solve which is not likely already solved b...
- 16 Sep 2019, 08:57
- Forum: Ask for Help (v1)
- Topic: Better than Excel? Nested match offsetting amounts for accounting
- Replies: 10
- Views: 1337
Re: Better than Excel? Nested match offsetting amounts for accounting
Wow Chunjee, a lot to look at
So this is not AHK? What is it? It's going to be busy for me today, but I will try to look through it later in a week
So this is not AHK? What is it? It's going to be busy for me today, but I will try to look through it later in a week
- 12 Sep 2019, 09:30
- Forum: Ask for Help (v1)
- Topic: Better than Excel? Nested match offsetting amounts for accounting
- Replies: 10
- Views: 1337
Re: Better than Excel? Nested match offsetting amounts for accounting
Hey Chunjee - Happy 100th post
I have an Excel file attached in original post above - it shows up at the bottom as a hyperlink when I look at it
Pretty sure I have a VBA to break out vendors into own sheets, which would reduce the volume of data to deal with an once
I have an Excel file attached in original post above - it shows up at the bottom as a hyperlink when I look at it
Pretty sure I have a VBA to break out vendors into own sheets, which would reduce the volume of data to deal with an once
- 12 Sep 2019, 08:44
- Forum: Ask for Help (v1)
- Topic: Better than Excel? Nested match offsetting amounts for accounting
- Replies: 10
- Views: 1337
Better than Excel? Nested match offsetting amounts for accounting
Hi Wizards, Wondering whether AHK can handle below better than Excel, in particular in terms of speed (and reliability of course as well) 20,000 rows of data Need code to identify matching offsetting amounts (e.g. 500 and -500) But match has to be found nested within first Vendor Number, then Projec...
- 06 Sep 2019, 15:35
- Forum: Ask for Help (v1)
- Topic: Text to speech upon activating the script Topic is solved
- Replies: 1
- Views: 1156
Text to speech upon activating the script Topic is solved
Hello Wizards, Need AHK to execute below line of code at a time once script is activated. Kind of like VBA onOpen in Excel. So, once I activate the script file and it is now active and listening for keyboard shortcut to run the main part of it, want it to execute this line without any keyboard short...
- 30 Aug 2019, 12:06
- Forum: Ask for Help (v1)
- Topic: Active window position and size change Topic is solved
- Replies: 9
- Views: 1199
Re: Active window position and size change Topic is solved
I guess it might be solved by use of If Active Window is Chrome then use one set of parameters, else another set of parameters My Window Spy has following info and second line seems to stay the same from one Chrome to another AutoHotkey Community - Post a reply - Google Chrome ahk_class Chrome_Widge...
- 30 Aug 2019, 10:19
- Forum: Ask for Help (v1)
- Topic: Active window position and size change Topic is solved
- Replies: 9
- Views: 1199
Re: Active window position and size change Topic is solved
Thank you much!
Noticing though exact same parameters for window location and size are taken differently when applied to MS Office programs vs Chrome browser for example - they don't take exact same location and size
Any ideas on that?
Noticing though exact same parameters for window location and size are taken differently when applied to MS Office programs vs Chrome browser for example - they don't take exact same location and size
Any ideas on that?
- 30 Aug 2019, 09:30
- Forum: Ask for Help (v1)
- Topic: Active window position and size change Topic is solved
- Replies: 9
- Views: 1199
Re: Active window position and size change Topic is solved
Probably something along these lines, but what else for Active Window part?
Code: Select all
^+Z::
WinMove, 1913, 7 [1934, 913]
Return
- 30 Aug 2019, 09:16
- Forum: Ask for Help (v1)
- Topic: Active window position and size change Topic is solved
- Replies: 9
- Views: 1199
Active window position and size change Topic is solved
Hello Wizards
Need a script for Active window position and size change
At Ctrl Shift Z switch to position
x 1913
y 7
w 1934
h 913
Need a script for Active window position and size change
At Ctrl Shift Z switch to position
x 1913
y 7
w 1934
h 913
- 12 Aug 2019, 11:21
- Forum: Ask for Help (v1)
- Topic: Parse a clipboard in parts Topic is solved
- Replies: 8
- Views: 1967
Re: Parse a clipboard in parts Topic is solved
I knew it!
But thank you.
But thank you.
- 12 Aug 2019, 11:13
- Forum: Ask for Help (v1)
- Topic: Parse a clipboard in parts Topic is solved
- Replies: 8
- Views: 1967
Re: Parse a clipboard in parts Topic is solved
I am now trying to get this script to Exit after finishing running once, so I added ExitApp at end, but it does not exit, stays active in the Task Tray I believe it's called Here's what I have: ^t:: rows := StrSplit(Clipboard, "`r`n") Loop % rows.length() { colu := StrSplit(rows[A_Index], "`t") Send...
- 16 Jul 2019, 15:37
- Forum: Ask for Help (v1)
- Topic: Parse a clipboard in parts Topic is solved
- Replies: 8
- Views: 1967
Re: Parse a clipboard in parts Topic is solved
Nice
And Congrats with your post # 400
And Congrats with your post # 400
- 16 Jul 2019, 14:54
- Forum: Ask for Help (v1)
- Topic: Parse a clipboard in parts Topic is solved
- Replies: 8
- Views: 1967
Re: Parse a clipboard in parts Topic is solved
The script I am currently running is below - it is only different from your latest above in that I have it hit enter key 3 times and not 2. I am wondering if you could think of a way to modify this script to ensure that once the clipboard has nothing left to paste at end of the loop, script only hit...
- 25 Jun 2019, 15:35
- Forum: Ask for Help (v1)
- Topic: Parse a clipboard in parts Topic is solved
- Replies: 8
- Views: 1967
Parse a clipboard in parts Topic is solved
Start: I have two columns of data in Excel with multiple rows, i manually select that range and copy AHK to do: a) by emulating Alt, E, P keys paste first cell from clipboards initial range, b) pause 300, c) paste second cell from same row of initial range, d) then hit Enter twice, e) then repeat th...
- 30 May 2019, 15:11
- Forum: Ask for Help (v1)
- Topic: Convert AHK script into VBA and run from Excel
- Replies: 1
- Views: 1032
Convert AHK script into VBA and run from Excel
I am new to AHK, and discovered it's awesome capabilities, which I have not seen done by VBA. AHK is part of RPA, but is likely frowned upon by employers, while VBA as part of MS Office is perfectly acceptable. Looking for a way to find a loophole to make it work. Question: is there a way to "conver...