DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: From within GTA to Excel  (Read 13,024 times)

HelmutWe

  • Supporting Member
  • Joined in 2018
  • **
  • Posts: 62
From within GTA to Excel
« on: April 20, 2020, 05:55 AM »
Looking for a new challenge I got the idea of updating an Excel table from within GTA, e.g. having Excel adding "1" to the sum of a row (another won GTA race). I don't think programming Excel using Visual Basic would be a problem.  I could manage that some 20 years ago. But not leaving a running game, not even change the application <alt>+<tab>,  certainly is. Any ideas are highly welcome.
And the best that you can hope for is to die in your sleep (Schlitz/Rogers)

Ath

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 3,649
    • Participated in NANY Challenge Eleven Times
    • Coding Snacks
    • Linux User
    • Hardware Hacker
Re: From within GTA to Excel
« Reply #1 on: April 20, 2020, 06:27 PM »
You can instantiate an Excel COM object, and manipulate it completely from there, so I think you'll manage that fine. Lots of resources to be found in 'da google' when you get stuck ;)
/Ton
Ath's software collection, Quote: "A problem well stated is a problem half-solved." (Charles Kettering)

HelmutWe

  • Supporting Member
  • Joined in 2018
  • **
  • Posts: 62
Re: From within GTA to Excel
« Reply #2 on: April 20, 2020, 08:22 PM »
My question was above all how pass a keystroke to windows from within GTA. Excel would not be the problem. If I could pass any keystroke from within GTA to windows then that would be a progress.
And the best that you can hope for is to die in your sleep (Schlitz/Rogers)

Deozaan

  • Charter Member
  • Joined in 2006
  • ***
  • Posts: 9,827
    • Participated in NANY Challenge Eight Times
    • Cody Award
Re: From within GTA to Excel
« Reply #3 on: April 21, 2020, 03:50 AM »
Maybe AutoHotKey could be used to catch keystrokes and send them to Excel?

HelmutWe

  • Supporting Member
  • Joined in 2018
  • **
  • Posts: 62
Re: From within GTA to Excel
« Reply #4 on: April 21, 2020, 04:37 AM »
Thank you. I got that hint from several sides. I would be happy if I could control Excel at all from within GTA. I don't need to collect data from the game. I fancy an open workbook and worksheet in the background. All I want as a start is to write "1" to a column's last cell. I once was half an expert in Word-VBA and Excel-VBA and am fighting HKA at present. It works in GTA sometimes, meaning I can sent keystrokes to the game in certain situations e.g. if the text-dialogue is open, I can't open nor can I close the dialogue, however.
And the best that you can hope for is to die in your sleep (Schlitz/Rogers)

wraith808

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 11,205
    • Participated in NANY Challenge Fourteen Times
    • Coding Snacks
    • Writer
    • Hardware Hacker
Re: From within GTA to Excel
« Reply #5 on: April 21, 2020, 04:07 PM »
I think what you're seeing is the fact that listening from multiple sources can cause a source not to get the message depending on how the first in the chain deals with the message.

Original address: https://www.donationcoder.com/forum/index.php?topic=49825.0