I am using XLOpen in a macro, but now have a situation where the desired file is already open for other reasons. In this case, MS opens a second, read-only copy. Since my macro is wanting to write to the open file, this does not work. Is there a way to either use XLOpen with a file that is already o...

JRL and armsys, Thank you for these replies. I see now where JRL is headed. I would have a 'master' MS macro for each global hotkey and, based on checking for the active window, I could have two, three or even a dozen different ways of responding to CTRL-1, depending on which window/app was active. ...

Yes, thank you, JRL, that's a very helpful explanation. I have removed the global hotkey definition from my MS macro and used the following AutoHotKey macro to define Ctrl-1 only for my OptionVue program. AHK will simply pass through the Ctrl-1 hotkey, if my desired application is not the active one...

I have written a simple macro for one application and assigned Ctrl-1 as the global hotkey. I now have another (unrelated) application that, out-of-the-box, uses Ctrl-1 as a hotkey for its own purposes. Is there a way to rewrite my MacrosScheduler macro, still using Ctrl-1 as its global hotkey, so t...

Great! I'll give it a try. Thank you.

armsys,

Great question. I would like to know that as well.

Ken

Thank you, JRL. That's great. I couldn't figure out a way to see the Watch List when using Modal Messages, so your solution is perfect.

Ken

How does one debug a script that uses GetActiveWindow? If I insert modal messages into the code below, and then run the script outside the debugger, it works fine. (I.e., num_matches = 1) I love the debugging tool, but it obviously thinks the MS Editor is the active window and so will not correctly ...

Marcus, There is a blog entry from 2006 that mentions Textract as a good choice for OCR work and shows how to integrate it into MS. https://www.mjtnet.com/blog/2006/06/06/screen-ocr-recognising-graphical-text/ Is Textract still a good tool for this, or are you aware of better alternatives now some n...

Thank you, Marcus. Maybe I'll take a stab at it. I don't know enough about AHK to know how it is being done there, but it seems like all the tools and functionality of MS would offer real advantages. Having used the AHK script a bit, I can say that there are some screens where it could function much...

I am wondering if anyone has used MS to do a script like this SansMouse AHK script to emulate mouse navigation. It has a very interesting concept of 26 zones on the screen. You can almost click anywhere on the screen in three, maybe four, keystrokes. I don't know AHK well enough to write this, but h...

A reboot of my computer and now I can use the backtick by itself. Odd.

Thank you for the confirmation,

Ken

JRL's response is interesting. When I hit the backtick key *alone* (without Alt), my copy of MS still inserts the Alt.

I would like to use as a hot-key for a macro the apostrophe-like symbol that is on the same key as the tilde. (The tilde is the shift character and the apostrophe-like character underneath it is without shift). I don't know what the key is called, but I don't ever need it for typing. However, when I...

PaulSR wrote:Hmmm not sure as it works fine for me.

Is the data in the cells D7:D30 formatted as per your original post? (00:00:00 time format)?

I am interested in the same question and tried out Paul's code. It is working fine for me, using the information on the data provided in the initial email.

Ken