i wan to use a vba code to run a autohotkey script at K:\filepath\studing.ahk
i used the following code but it brings up the debugger:
please helpPlease Login or Register to view this content.
i wan to use a vba code to run a autohotkey script at K:\filepath\studing.ahk
i used the following code but it brings up the debugger:
please helpPlease Login or Register to view this content.
Total guess and untested, but try:
Or evenPlease Login or Register to view this content.
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Try adding double double-quotes for the program too …
thank you Marc L and TMS, it was the "" quotes!
You're welcome. Thanks for the rep.
Did you need more or less double quotes?
Thanks to all on this thread. Your posts provided just what I needed to leverage ahk scripting with some of my Excel vba routines.
NOTE 1: the "" is required on both sides of the fully qualified path \scriptname.ahk
NOTE 2: the ("………….") are required to fully enclose the SHELL path\scriptname
NOTE 3: In vba, Breaking a shell command line with " _" is NOT allowed!
Vba example follows:
Sub Test()
Shell ("C:\Program Files\AutoHotkey\AutoHotkey.exe ""C:\Users\Wayne\Software Installed\Auto Hotkey - AHK\AHK Scripts\test.ahk""")
End Sub
The above routine is called by an Excel sheet \ button to which the linked Sub is assigned.
Tested - OK 9/5/2020
Last edited by wddogger; 09-05-2020 at 07:47 PM. Reason: grammar
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks