Author Topic: Anyone use or familiar with AutoHotKey?  (Read 778 times)

Offline CountValentine

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Mar 2013
  • Posts: 12185
  • Total likes: 4296
  • DansDeals.com Hat Tips -1
  • Gender: Female
    • View Profile
  • Location: Poland - Exiled
  • Programs: DAOTYA, DDF Level 3, 5K Lounge
Anyone use or familiar with AutoHotKey?
« on: September 23, 2019, 06:36:50 PM »
I am trying to pull info from Excel into web form using AHK.
You're so far up Trump's a** you can see Giuliani's feet.  HT Baruch

Offline Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 4917
  • Total likes: 1729
  • DansDeals.com Hat Tips 45
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #1 on: January 28, 2022, 03:25:34 PM »
I am trying to pull info from Excel into web form using AHK.
Bump

Looking for someone a bit familiar. I'm looking to pull data from google sheets I have something set up but it's being glichy.
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Offline Euclid

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 3427
  • Total likes: 3340
  • DansDeals.com Hat Tips 3
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #2 on: January 29, 2022, 07:53:53 PM »
Bump

Looking for someone a bit familiar. I'm looking to pull data from google sheets I have something set up but it's being glichy.
Don't they have an API? Why would you want to use AHK?

Offline Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 4917
  • Total likes: 1729
  • DansDeals.com Hat Tips 45
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #3 on: January 30, 2022, 12:14:36 AM »
Don't they have an API? Why would you want to use AHK?
Your referring to google app script?

In short I'm using an existing spreadsheet (that sometimes changes) I don't want to mess with the sheet, I would just like to get data from a row and I then have a waitkey which waits till I press the shortcut and then it populates the appropriate fields. It works really well when it it works ;D

The main 2 issues are that A. The wait key sometimes doesn't wait. B. The way I get information from the cells is by having it press the left and right arrows and copying each field, but it doesn't always get the right fields.
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/

Offline Live N Learn

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2015
  • Posts: 3655
  • Total likes: 263
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #4 on: January 30, 2022, 04:10:31 AM »


Your referring to google app script?

In short I'm using an existing spreadsheet (that sometimes changes) I don't want to mess with the sheet, I would just like to get data from a row and I then have a waitkey which waits till I press the shortcut and then it populates the appropriate fields. It works really well when it it works ;D

The main 2 issues are that A. The wait key sometimes doesn't wait. B. The way I get information from the cells is by having it press the left and right arrows and copying each field, but it doesn't always get the right fields.


For issue B, you can try to add a sleep between each stroke and play around with the timing to get it right and short.
".איזהו חכם, הלומד מכל אדם"

Offline Yo ssi

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Aug 2019
  • Posts: 4917
  • Total likes: 1729
  • DansDeals.com Hat Tips 45
  • Gender: Male
    • View Profile
Re: Anyone use or familiar with AutoHotKey?
« Reply #5 on: January 30, 2022, 10:58:10 AM »
For issue B, you can try to add a sleep between each stroke and play around with the timing to get it right and short.
Exactly what I tried. It seems it's unrelated to the timing, it just sometimes works and sometimes doesn't :-\
_    ,
' )  /
 /  / __   _   _   o
(__/_(_)  /_)_/_)_<_
 //
(/