Jump to content
Macro Express Forums

acantor

Members
  • Content Count

    1,156
  • Joined

  • Last visited

  • Days Won

    8

acantor last won the day on March 4

acantor had the most liked content!

Community Reputation

11 Good

About acantor

  • Rank
    Master

Contact Methods

  • Website URL
    www.cantoraccess.com
  • ICQ
    0

Profile Information

  • Location
    Toronto

Recent Profile Visitors

802 profile views
  1. The solution to this challenge is more challenging to achieve than I anticipated. (When I originally posted it, my solution was flawed. For example, the first and last word of a document must be handled differently than words in the middle.) The difficulties relate to the rules I set out, which I erroneously imagined would simplify matters! 1. Rotate a word through three states: lowercase ... Titlecase ... UPPERCASE ... lowercase etc. 2. The word is NOT selected. This means the macro must somehow capture a word without knowing where the word starts and
  2. At this point, my only suggestion is put your energies into forcing the macro to reliably give the window focus. Start afresh. Create a new macro, and keep messing with it until you find the steps to give focus to the window under the mouse pointer. Experiment with code excerpts such as these: Mouse Left Click Mouse Left Click Delay: 100 milliseconds Mouse Left Click Mouse Left Button Down Delay: 100 milliseconds Mouse Left Button Up Capture Control from Beneath the Mouse into %ControlUnderMouse% Delay: 100 milliseconds Mouse Click on Control %ControlUnderMouse%
  3. Then try this, which may or may not need a delay between steps: Capture Control from Beneath the Mouse into %ControlUnderMouse% Set Focus to %ControlUnderMouse% <CAPTURE CONTROL Option="\x00" Control="%ControlUnderMouse%" UseText="FALSE"/> <SET FOCUS Control="%ControlUnderMouse%"/>
  4. That's what my admittedly untested script is supposed to do. It clicks on whatever object the mouse pointer is hovering over. If the script fails because the object isn't gaining focus after it's clicked on, the first modification I would try is insert a delay between the two statements. Start with 1 second or 0.5 seconds. Through trial and error experimentation, reduce the delay until you've figured out how short it needs to be.
  5. That doesn't sound too hard to do with Macro Express. Do I understand this correctly? You click a mouse button, which causes the mouse to output Ctrl + S or Ctrl + B? If so, the macro might look like this: Mouse Left Click Text Type (Simulate Keystrokes): <CONTROL>b
  6. In many applications, there are hotkeys for switching between different windows, but the hotkeys may not be well documented. Here are a few key combinations to experiment with: F6 Alt + F6 Ctrl + F6 Ctrl + Tab Ctrl + Page Up Ctrl + Page Down I've seen applications that include window switching commands in its menus. For example, in Microsoft Word 2019, the key sequence for getting close to the window switching command is: Alt (or F10) W (View) W (Switch Window) Up and down arrow keys (to select a window) Enter
  7. When I use floating menus (Macro Express 6, Windows 10) I only see tooltips upon hover when the floating menu has focus. If the floating menu is not the active window, then no tooltips.
  8. Try variations of the text you've already inserted in the "IP Address/Hostname" field, but don't include "https://" or "ftp://" or anything similar. For example, when I ping Microsoft's web-based Outlook service, the field reads "outlook.com" but I remember, maybe a year ago, changing it from something else.
  9. This challenge is a little more challenging than the last one. It's actually kind of hard. Macro Express is probably not the ideal tool for tackling this problem, but the fact that it's do-able in Macro Express is testament to the program's versatility. In Microsoft Word, there is a built-in command called "Case Rotate" that changes text from lowercase to title case, from title case to uppercase, and from uppercase to lowercase. The default hotkey is Shift + F3. This hotkey also works in PowerPoint, and in HTML and RTF email messages in Outlook. The challenge: Use Mac
  10. Terry, your last response has led me to the conclusion that I was overthinking this! I tried three different ways to select the contents of a cell, all of which involved Edit mode. After reading your message, I realized there was a fourth way: forget about Edit mode. Simply copy! And with that realization, the only fail-safe needed is to make sure the cell is NOT in Edit mode. (In Edit mode, content must be selected before copying.) Pressing <ESC> exits Edit mode, and does nothing in Ready or End mode. // Cancel "Edit" mode (does nothing if no
  11. Hi Terry, This challenge is not nearly as complex as others that have appeared in this forum, but at the same time, it's not quite as straightforward as it seems. For example, there are many ways to retrieve the contents of a cell so the value can be passed to the macro. I'm aware of three methods. But the methods are not equally reliable. When I tried to "translate" Method 1 into Macro Express code, the script got convoluted. Method 2 failed. Method 3 seems to maximize reliability: So far, it works regardless of the initial state of a cell: whether it has k
  12. Hi Cory, For the sake of this challenge, assume that some cells need to be repaired, and some don't; and that the cells in need of repair are not necessarily contiguous. In other words, the repair cannot be applied to an entire column of cells. The repair must be applied to individual cells based on other criteria, e.g., expenses that were entered into the spreadsheet on certain days, or whatever.
  13. I track my expenses in an Excel spreadsheet. For most expenses, I pay 13% in taxes. For example, if the pre-tax value for an item is $100, I pay a total of $113. I set up my spreadsheet to accept pre-tax values. The spreadsheet uses formulas to calculate the amount of tax I paid on an item, and then sums the two: Pre-tax Tax Total 100.00 13.00 $113.00 10.00 1.30 $11.30 1.00 0.13 $1.13 Unfortunately, I accidentally inputted hundreds of expenses before r
  14. I hope you'll post your completed (or almost completed!) script after you're happy with it.
  15. Glad my script set you in the right direction. I imagine you'll be able to tweak the script to do what you need it to do. I've been using Macro Express for about 20 years, and I'm still finding new ways to use the program to automate tasks, simplify routine operations, and repair accessibility and usability problems.
×
×
  • Create New...