Loop Pulling 1st Variable's Data Into 2nd Iteration

Get help with using AutoHotkey and its commands and hotkeys
Trippet
Posts: 3
Joined: 08 Mar 2018, 13:37

Loop Pulling 1st Variable's Data Into 2nd Iteration

08 Mar 2018, 14:26

The first set kicks off when I press Ctl Alt C, and copies across 5 fields in Excel, assigning each field to a variable, for as many loops as I designate. No problems there, working great.

The second set kicks off with Ctl Alt V and it enters the variables into QuickBooks. It's working Except for the "qbacct" variable. For some reason that I can't figure out it reuses the first iteration for the 2nd iteration's "qbacct" value. It's only the 2nd iteration. Everything else works fine, and that's what's perplexing. Usually it's a nothing works or everything works deal, not an arbitrary, just this guy doesn't work.

I did my best to show the Excel set up and the AHK result below, and attached a sample of my Excel file just in case. The second line in the result should be "02.10 Fill Dirt", but instead it's returning "02.30". Any ideas?

From Excel:
AHK Script Help.xlsx
(9.69 KiB) Downloaded 2 times

    Pro Touch A-02 02.30 Land Clearing Inv 6494 2100.00
    Pro A-02 02.10 Fill Dirt Inv 6494 2700.00
    Pro Touch A-02 02.30 Land Clearing Inv 6494 650.00
    Pro Touch A-02 02.40 Grade Pad Inv 6494 350.00
    Pro Touch I-18 02.60 Rough Grade Inv 6493 200.00
    Pro Touch R-01 02.60 Rough Grade Inv 6495 200.00

AHK Output to QuickBooks:

    02.30 A-02: Inv 6494 - 02.30 Land Clearing 2100.00 A-02
    02.30 A-02: Inv 6494 - 02.30 2700.00 A-02
    02.30 A-02: Inv 6494 - 02.30 Land Clearing 650.00 A-02
    02.40 A-02: Inv 6494 - 02.40 Grade Pad 350.00 A-02
    02.60 I-18: Inv 6493 - 02.60 Rough Grade 200.00 I-18

Code: [Select all] [Expand] [Download] GeSHi © Codebox Plus


Code: [Select all] [Expand] [Download] GeSHi © Codebox Plus

Trippet
Posts: 3
Joined: 08 Mar 2018, 13:37

Re: Loop Pulling 1st Variable's Data Into 2nd Iteration

08 Mar 2018, 23:36

Duh. Using qbacct2 as a variable kind of sort of breaks the script's a_index value's ability to work when I'm already using qbacct as a variable. By renaming qbacct2 to qbcat or Anything else that doesn't end in a number I will correct the issue. I needed a few hours away from the computer to let the brain rejuice. Hopefully this will help someone else have a V-8 moment in the future.

Return to “Ask For Help”

Who is online

Users browsing this forum: Xtra and 13 guests