Automate 'replace with passage' in Word Add-in using keyboard shortcut?
Hi, has anyone been able to automate in Word the Add-in to replace a reference with the passage? (Right-click > Additional Actions > Replace with passage) I've tried to record a macro to do it, but it won't record right-clicks. VBA Sendkeys doesn't work either, and isn't a good way to do it in any case. With the need to do this so many times, it would be great to have it on a keyboard shortcut. Has anyone been able to do this or something similar?
Comments
-
I'm with you! Have you been able to figure this out in the past 2.5 years, John?
It looks like no one replied to you.
0 -
I haven't tried it myself, but this seems like the kind of problem AutoHotkey may be able to solve: http://www.autohotkey.com/
0 -
I use AutoHotkey for other shortcuts, and it is great. But if my memory is correct, having tried that (as well as a Word Macro, in VBA), the problem was in identifying what keystrokes could be used to do so in code. That is, how to activate the right-click menu and navigate through it to the desired item under 'Additional Actions'. Getting the right sequence of commands was the problem, as one or more were not available for code implementation. Yet, that might be down to my lack of programming ability (or ability to search on the web for solutions!), and it might still be technically feasible.
It's not a big matter, by any means, but with lots of repetitive actions in Word, it would have been great to be able to automate it using a function key or similar.
0 -
I came across a solution to this the other day. Instead of a one-button macro solution, a keyboard shortcut works instead.
If I highlight a verse reference in a Word document, then press shift+F10, then press a, then press b, the desired verse is shown in Logos Copy Verses.
Now all I need is a 'reliable' keyboard method to 'Copy and Paste' into Word without having to use my mouse. Unfortunately, alt+p doesn't always work in Logos if the focus is in the wrong place in Logos beforehand. But that's a minor quibble. I'm just pleased to be able to copy and paste verses now without having to right-click on the text.
0 -
Good Day,
Be Blessed, although very long after the initial post!
- This script make use of AutoHotKey, LogosComApi and Internet Explorer
- Open the Script file and Edit line 11 to your preferred language
- Run the script
- Select a Reference that is replacable in any Application:
- Win + B : will replace the selected Reference with Bible Text
- To set the style Press Ctrl+Alt+B and set the Preffered style in the Copy Bible Verses dialog. Then close it. Retry 3.1 to see the result
- If Bible text or a paragraph contains to many line-feeds, select it:
- Ctrl + R : will remove the line-feeds from selected text and combine it into one paragraph.
- If you have text in a foreign language and want to translate it to your own default language, select it:
- Ctrl + T : will translate the selected text to your preferred language
This is very usefull to me and I use it a lot in Sermon Editor to replace long Psalms with a single paragraph to make it manageable in printouts. I also translate Sermon Outlines copied from Sermon Starter Guide to Sermon Editor.
150 -
Pieter said:
Good Day,
Be Blessed, although very long after the initial post!
- This script make use of AutoHotKey, LogosComApi and Internet Explorer
- Open the Script file and Edit line 11 to your preferred language
- Run the script
- Select a Reference that is replacable in any Application:
- Win + B : will replace the selected Reference with Bible Text
- To set the style Press Ctrl+Alt+B and set the Preffered style in the Copy Bible Verses dialog. Then close it. Retry 3.1 to see the result
- If Bible text or a paragraph contains to many line-feeds, select it:
- Ctrl + R : will remove the line-feeds from selected text and combine it into one paragraph.
- If you have text in a foreign language and want to translate it to your own default language, select it:
- Ctrl + T : will translate the selected text to your preferred language
This is very usefull to me and I use it a lot in Sermon Editor to replace long Psalms with a single paragraph to make it manageable in printouts. I also translate Sermon Outlines copied from Sermon Starter Guide to Sermon Editor.
15
Hi Pieter,
That works just great. That will save much time. Thank you very much.
It even works when drafting an email in Outlook and when drafting text messages using my keyboard when my mobile is connected to the PC. And the undo (Ctrl+Z) works to change it back too.
It is far better than my recent workaround which was to use the keyboard instead of right-clicking on the mouse to use the copy Bible verse Word addin (although the 3 x Tab only works if the focus is on the right place initially in Logos) Shift+F10, A, B, Tab, Tab, Tab, Return.
The Ctrl+T works great too, as I often have to translate some text, and Google translate is often a good starting point (while it generally needs a quick check by someone more fluent in the language too). It even works on webpages, including the Google search box.
Many thanks.
Thank you so much.
0 -
Hi John,
I'm so glad that I could help out. I decided to optimize the script for you, never thought it would be useful to someone else, therefore never improved on it. The script is now more readable and replacement is much faster, almost immediately. You can also easily define your own Hotkey for each function - see the section - Define Hotkeys. If you need any other automation I would be glad to assist if possible.
130 -
Pieter said:
Hi John,
I'm so glad that I could help out. I decided to optimize the script for you, never thought it would be useful to someone else, therefore never improved on it. The script is now more readable and replacement is much faster, almost immediately. You can also easily define your own Hotkey for each function - see the section - Define Hotkeys. If you need any other automation I would be glad to assist if possible.
13
Hi Pieter,
What can I say, but thank you once again. That is great. I'm sure a lot of other users will find it a real help too. The Define Hotkeys at the start of the script is helpful too.
Can I suggest that you add it to the wiki here: https://wiki.logos.com/Tools_and_Files_supplied_by_users
Thank you once again for this time-saving script that works in so many programs, not just Word.
0 -
Hi Pieter,
I was having a little difficulty using this the other day. Sometimes it came up with the error "Your selection doesn't seem to be a Bible Reference" when what was highlighted was clearly a Bible verse. At other times it simply didn't do anything. Logos was running each time I tried this.
I wonder, is there a program startup sequence which I need to follow? Do I need to have Logos running before I launch the AHK file, or vice versa? I launch my AHK files at startup, and I launch Logos when needed after that. Is that a problem?
0 -
Hi John,
Thanks for informing me of this bug.
The script attach itself to Logos using the LogosComApi. This means it always start Logos when the script runs for the first time. I never shut down Logos or the Script therefore I didn't notice the bug.
If the script is running and you shut down Logos and/or restart Logos the script doesn't update to the new instance of Logos. This is due to bad error handling on my side.
Some techincal info: At startup Line 26 jumps to line 32 (GetLogos). When the script is running and you shut down Logos, with the script still running, the script jumps from the hotkey Win + B to line 52, skipping the GetLogos jump in line 26. The fix would possibly be to check if the Logos Application is attached each time Line 52 (CopyBibleVerseAction) executes. I added Code to Line 57 and 58 to do this -
57 If (!App)
58 gosub GetLogosThis should fix the issue - if not, please let me know then I'll try and rethink the code again. The code would now behave a little bit differently: When it looses the Logos instance you will see the Logos Startup Screen if it needs to re-attach to Logos Bible Software. This mean that even if you shut down Logos and the script is running, Win + B will trigger a Logos startup.
230 -
The bug is bigger than I thought, I'll fix it and post the working update.
150 -
Pieter said:
The bug is bigger than I thought, I'll fix it and post the working update.
15
Thanks for looking at it.
I know a little programming, not enough to program but enough to have a bit of an idea of what I'm looking at sometimes. Instead of trying to automatically launch Logos again within the app, if ~B is used some time later after Logos has been closed, how about just using the message box to ask the user to check not only the syntax of the reference, but also to check if Logos is running, and if necessary to launch Logos and reload the script and try again.
0 -
That's a great idea. I discovered the bug and it seems to be a bit beyond my range of knowledge of ahk. I'll design a workaround tomorrow in my thoughts and then code it as soon as possible. The problem is that the App variable holding Logos doesn't get released when Logos is Exiting. This restrickt me in validating the variable with if !App before attatching to launcher.application
0 -
Pieter said:
That's a great idea. I discovered the bug and it seems to be a bit beyond my range of knowledge of ahk. I'll design a workaround tomorrow in my thoughts and then code it as soon as possible. The problem is that the App variable holding Logos doesn't get released when Logos is Exiting. This restrickt me in validating the variable with if !App before attatching to launcher.application
Yes, I had experimented with commenting out the first GetLogos and moving the !App and GetLogos in the #B section to just after the msgbox, but it didn't work, for the reason which you have outlined. Knowing how it works helps know how best to use it. But it works great now that I know.
Thanks again for this great script.
0 -
Several things fixed:
- I removed the SingleInstance directive and force my own Instance through code. This does not prevent the script to have more than one instance running, it only ensures one instance if the script starts itself.
- ClipWait breaks Win + B on the third time I restart Logos, so I removed all code for ClipWait. I placed it on line 56.
- The script now completely restarts itself (on Win +
when Logos is not running to ensure that all variables are released and reloaded. This cause the script to start Logos automatically if not running and Win + B is pressed. - If the script is running and Logos get closed, there is a time-frame in which the script thinks that Logos is still open. This will be visible when Win + B fails to replace a reference in this time-frame. Just wait a few seconds and try Win + B again - the script will then start Logos and replace the reference and function normally.
I hope this is all and that I didn't miss some other bugs.
780 -
Pieter, thank you once again. This is a great script. Love it. Thanks for your hard work on it. I hope others find it helpful too for working in Word or any other Windows based program.
0
