Jump to content
Macro Express Forums


  • Posts

  • Joined

  • Last visited

  • Days Won


Everything posted by rberq

  1. An integer variable may be set to the position of a substring within the text. So if you find it at position 1, then "replace". There's an option within "replace" to do it once only, or for all occurrences.
  2. Some consolation! I suspect Microsoft rewards their employee-of-the-month by saying, "Here's a popular product, go ahead and have some fun by making whatever random design change strikes your fancy." I just spent 30 minutes trying to turn off an "error" option in Excel. I could turn it off for a particular spreadsheet but it would turn itself back on almost immediately. Finally read an online hint to click File and Options, and that way I could turn it off universally and it would stay off. The oddest thing is, this is a monthly spreadsheet and the "errors" just started showing up this month, after seven years of data. Must have been from one of those Office updates that sneaked in without telling me now that I'm on Windows 10. Things like this no longer surprise me, just reinforce my love/hate relationship with Microsoft.
  3. I use a variant of this technique for saving e-mails to existing folders, though not for creating new folders since I do that only rarely. Some email sources have a consistent window title, others can be reliably identified by phrases in their content or simply by the "to" or "from" fields. To dispose of an email that's on the screen, I start a macro that analyzes these items, sends it to the appropriate folder, or deletes it if it doesn't qualify for saving. I admit the macro clicks on screen icons to do its work, so when GMail changes its layout the macro has to be adjusted. But that doesn't happen often.
  4. I ran ME 3 for many months on Win 10. I don't remember whether it asked that on the very first startup, but it was OK otherwise. Are you saying it asks every time it starts?
  5. You could look into the instruction "Wait for Key Press" which has many wait options other than "key." You might be able to do something with that. You can start a macro (or multiple macros) that just sit on the Wait instruction, then when the key-press occurs the waiting macro can run some other macro. Unfortunately the wait appears to deal only with three mouse keys, not four or five, but you could potentially set up a combination of mouse keys or letters. It might be tricky and involve multiple macros. Good luck!
  6. So don't keep me in suspense! I'm apparently doing my activations incorrectly, also. Please tell! 😬
  7. For what it's worth -- Here are some hints from another forum that I follow. No warranty expressed or implied. Always remember: "Microsoft is arrogant and will *tell you* what you want" and "Google wants to know and control everything about you, all the time" To that end, here are some easy tips to speed up Win 10. 1. Ctrl-Shift-Esc for task manager, go to Startup tab. Disable Onedrive. 2. Hit windows key, search for 'background apps' Turn them all off 3. Open Chrome. Settings, Advanced. a. Preload pages- off b. Continue running background apps - off 4. If using SSD, turn off SysMain service 5. Install AVG free (if home computer). Disable AVG Secure brower, disable Web Shield, disable cleanup. (MS Defender will move out of the way, it is VERY SLOW) 6. Add Malwarebytes free (if home computer). Like AVG, the paid versions are 'too heavy' and drag down system performance. Bang, 10-30% increase from just those few things. The difference should be noticeable upon reboot. Consider upgrading to SSD drive. They are pretty cheap these days. In task manager you can look at performance tab and see if it is amount of memory, Processor, or disk drive that is the anchor. Memory is easily upgraded, disk drive intermediate (maybe difficult on some laptops) with cloning or reinstall necessary.
  8. Being south of the border, I had to send a check rather than a cheque. But my other question: What is ME 5? Is it just ME 4 under a different name? And still more questions: I tried to convert to from ME 3 to ME Pro back around 2009, for a pretty complex application running on 350 PCs, as I recall. Nothing much worked during testing, so I stayed with ME 3. I just recently converted my home PC from ME 3 to ME Pro, and I'm still seeing ME Pro crash about once a day. So to finally get to my questions: Did you experience any significant pain going to ME 6, or was it neat and clean? Was there an automated macro conversion involved, like there was in moving from ME 3 to ME Pro?
  9. That's called the bleeding edge. Must be a version 6 thing. Mine tells me it is, but no additional message. What is ME 5? Just updates to ME 4 under a different name so they can start charging for it? I got used to "free". I don't remember, but I think I paid about $15 for ME, and used the pre-Pro versions for about twenty years. That's 75 cents a year for a tool I said added 50% to my productivity. I always felt guilty when I installed updates, and worried that Insight would go out of business for lack of revenue.
  10. Yes, please. I immediately looked for an update beyond, but found none. Updating version 6, maybe?
  11. Now here's a cute idea. I started a macro that runs indefinitely -- entire macro is below. So whenever I press the ESC key the macro types your suggested sequence to close the active application window. Then the macro just waits until I'm ready to close another one. Works great with Windows 7, but again ME does not see the ESC key in many Windows 10 operating system screens, so still no dice. The other problem with this, even in Windows 7, is the limited number of keys that can be waited for. I'd rather use a key that is "never" used any other time. Repeat Until %A% Does not Equal %A% Wait for Key Press: ESC Text Type (Simulate Keystrokes): <ALTD><SPACE><ALTU> Delay: 100 milliseconds Text Type (Simulate Keystrokes): c End Repeat
  12. You have given me hope. I have a Windows 10 system on order, and I'll have a lot more time to experiment once I get everything else converted to it.
  13. Little things like that save a lot of time and aggravation when you are coding.
  14. Every bit as good as my method of finding the upper right corner and clicking on the "X". Except my macro closes just one tab at a time (Ctrl-w) if Firefox is the active application. But my problem is getting the macro to run at all, so that it can simulate the keystrokes you outlined. As Cory explained, in the UWP applications in Windows 10, ME never even sees the hotkey to trigger the macro. The beauty of the keypad-minus key is, many applications give you the option to save/no save your work when you exit, so I can just hit the minus key with my middle finger and roll my thumb down to the Enter key to confirm saving. Very fast, and no looking for keys. But I bet I can get used to a manual Alt-Space-c, if I have to.
  15. Yes! It does! So now if I can figure out the name of that little window, I'll see if it can trigger a macro that types the "c". You say it's called the Windows System menu?
  16. For example, the Windows Setup screen and the various screens that can be accessed from there.
  17. "Doesn't work with them", in this case, seems to mean that while the application is running, MEP doesn't see key strokes and therefore can't start macros. I have seen the same ME problem under Windows 7, with the Adobe PDF Reader. Adobe says the reader runs in Protected Mode as a security feature. With Adobe the Protected Mode can be turned off, and then ME is happy.
  18. Since my hands are most often on the keyboard, I prefer using keys to using the mouse. One of my most-used macros closes the current application. If Firefox is active, it types Ctrl-w to close the active tab. Otherwise, it clicks in the upper right corner of the active application’s window. The macro is activated by the keypad minus key, and it’s generally quicker to press the key than to manually maneuver the mouse or to press that awkward Alt-F4 combination. Here’s the problem: In many Windows 10 system screens, the key is ignored so the macro doesn’t run. Other hotkey combinations are also ignored – like Ctrl-Alt-w that runs a macro to display all open windows. Is there a Windows 10 setting, or some trick, to overcome this issue?
  19. Well, you learn something every day. Thanks, never knew that. Once the paragraph is selected, mouse operations seem to be affected. Clicking somewhere after the selected paragraph adds the intervening text to the selection. Haven't figured out how to turn it off once it has been turned on.
  20. Interestingly, my son had to do exactly this sort of thing in his job, though he had to actually type each entire response each time. I offered to give him a simple macro, but IT management would not allow ME to be installed on their computers. Troglodytes!
  21. The first thing I would do is get rid of the Word document. With text that short, it could just be embedded in the macro in Text Type commands. However, having the document makes it easy for the user to modify his text without having to involve a macro coder, so let’s keep Word involved. But modify the Word document so paragraphs are delineated by some simple character sequence such as ***. So the Word document is: ***I reached the client and explained the issue. I will follow up by mail. ***I left a voice mail message requesting a call back. ***I left a message with the person who answered the phone and asked that the client call me. ***The telephone number is not in service. I will send a letter. ***The client does not have telephone service. I will send a letter. *** The user would toggle to Word – actually I’d probably give him a macro to do the toggle – then use arrow keys to move anywhere within the paragraph to be selected, and start the macro with a key combination. The macro would then arrow back through the text until *** is located, determining the beginning of the paragraph. Then copy all text forward from that point into the clipboard, and select out the desired paragraph by scanning for the next *** (end of paragraph). Then the macro would switch to the database screen, tab to the proper field, and type or paste the variable containing the captured paragraph. Another method, for ease of two-finger use, would be to dispatch one of five “driver” macros using keys 1 through 5 of the keypad. Each macro corresponds to selecting one of the five paragraphs. A common called macro would then switch to Word, copy the entire Word document to the clipboard, and select out the desired text delineated by counting *** sequences. Then switch to the database screen and type or paste. I like the second method for ease of use, but it requires the user to memorize the paragraph number of each possible text selection. The first method is more flexible if there are too many paragraphs to commit to memory, or if they change often in number or content so memory isn’t feasible. As it has been years since the user has had to change text, he should have committed it to memory by now, so I’d go with method 2 though philosophically I like 1 better. Could also do this with a multiple choice menu, which does away with the user’s need to memorize, and also does away with most of the coding.
  22. I participate in one forum that has a "Flame Suit" section -- only enter if you have a tough skin (asbestos recommended) and are willing to hear what people really think -- better believe I have been reprimanded there. I glad your macro is working now.
  23. Be kind. He has been told this three times now across two or three threads. I think he's a newbie trying to get a feel for ME, so best not to scare him away. When I think of the questions I asked when I started using ME, most people must have assumed I was a total moron. Happily most of those posts are lost in the mists of history, but I could come up with more at any time. 🤔
  24. At the point where you want the date-typing macro to run, instead of triggering it with Ctrl-y, use the Macro Run command: Macro Run: Type_Date
  • Create New...