Search found 15 matches

by AC1
17 Sep 2019, 15:02
Forum: Other Utilities & Resources
Topic: Balance Sheet, Final Accounts, Accounting
Replies: 4
Views: 4419

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...
by AC1
16 Sep 2019, 08:57
Forum: Ask For Help
Topic: Better than Excel? Nested match offsetting amounts for accounting
Replies: 10
Views: 375

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
by AC1
12 Sep 2019, 09:30
Forum: Ask For Help
Topic: Better than Excel? Nested match offsetting amounts for accounting
Replies: 10
Views: 375

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
by AC1
12 Sep 2019, 08:44
Forum: Ask For Help
Topic: Better than Excel? Nested match offsetting amounts for accounting
Replies: 10
Views: 375

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...
by AC1
06 Sep 2019, 15:35
Forum: Ask For Help
Topic: Text to speech upon activating the script Topic is solved
Replies: 1
Views: 95

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...
by AC1
30 Aug 2019, 12:06
Forum: Ask For Help
Topic: Active window position and size change Topic is solved
Replies: 7
Views: 267

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...
by AC1
30 Aug 2019, 10:19
Forum: Ask For Help
Topic: Active window position and size change Topic is solved
Replies: 7
Views: 267

Re: Active window position and size change Topic is solved

Thank you much! :superhappy:
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?
by AC1
30 Aug 2019, 09:30
Forum: Ask For Help
Topic: Active window position and size change Topic is solved
Replies: 7
Views: 267

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
by AC1
30 Aug 2019, 09:16
Forum: Ask For Help
Topic: Active window position and size change Topic is solved
Replies: 7
Views: 267

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
by AC1
12 Aug 2019, 11:21
Forum: Ask For Help
Topic: Parse a clipboard in parts Topic is solved
Replies: 8
Views: 389

Re: Parse a clipboard in parts Topic is solved

I knew it!
But thank you.
by AC1
12 Aug 2019, 11:13
Forum: Ask For Help
Topic: Parse a clipboard in parts Topic is solved
Replies: 8
Views: 389

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...
by AC1
16 Jul 2019, 15:37
Forum: Ask For Help
Topic: Parse a clipboard in parts Topic is solved
Replies: 8
Views: 389

Re: Parse a clipboard in parts Topic is solved

Nice :superhappy:

And Congrats with your post # 400
by AC1
16 Jul 2019, 14:54
Forum: Ask For Help
Topic: Parse a clipboard in parts Topic is solved
Replies: 8
Views: 389

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...
by AC1
25 Jun 2019, 15:35
Forum: Ask For Help
Topic: Parse a clipboard in parts Topic is solved
Replies: 8
Views: 389

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...
by AC1
30 May 2019, 15:11
Forum: Ask For Help
Topic: Convert AHK script into VBA and run from Excel
Replies: 1
Views: 186

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

Go to advanced search