Get game controller (joystick) axis position in Excel VBA possible?

If you are using a Windows OS, you can use DirectX for this.

First, set references to "DirectX 7 for Visual Basic Type Library", and then put this code on "ThisWorkbook" module (not normal module) :

Please Login or Register  to view this content.

I just use the MsgBox to show how the code is working, if you want to put the result to an array, you (or other forum member here) should modify the code.


Regards

Thanks.

Should this also work on 64 bit Windows 10? In the references list, it says : "MISSING: DirectX 7 for Visual Basic Type Library"

I have found this file somewhere and put it in my System32 folder. After a reboot it is still reported as missing.
Shouldn't DirectX be backwards compatible? I downloaded DX7 and it won't install as it is not supported on my OS..

Edit: I've also ran DXWebSetup which puts a bunch of old Dx DLL files in there for compatibility with older games.

Edit2: It seems to work putting it in SysWOW64 and adding it to the registry. I'll be having a good play with the code!

Thanks,
Niels