Macro Recording and Automating Windows with Macro Scheduler – Tips & News
Twice today, for two different people, I needed to write some code to iterate through files in a tree of subfolders. The subfolder structure could not be known up front and there may be any number of subfolders and any number of folders deep. One could use GetDirList iteratively, or use VBScript’s FileSystem Object. But […]
Gale Dyvig has just posted some code in the forums showing how to use the Microsoft Office Document Imaging OCR component to locate text on the screen, find its position and click on it. Very useful. You’ll find it here. MODI is a component that comes with Microsoft Office. You need to ensure Microsoft Office […]
I just helped out a customer who was getting increasingly frustrated trying to get a macro to select a menu. The menu shortcut key was “g” and all he was trying to do was send Alt-g to the window. But whatever he tried he couldn’t get it to work. Being an experienced programmer who had […]
A project I’m currently working on involves populating data into a rather poorly designed user interface. A particular challenge were the drop down lists and list boxes due to the fact that you can’t “drill down” by sending the text of the item you want selected. The solution we settled upon uses the text capture […]
Some pre-sales questions we get seem to suggest that the user lacks basic Windows skills. What surprises me is that these questions are often from people working in company IT departments. Their ability to comprehend how to automate something appears to be diminished by their inability to use a PC effectively. Perhaps I’m being unfair […]
I’ve just finished writing a routine for a customer that automates what I can only describe as a truly horrendous user interface. I’m not sure who designed it or why they designed it the way they did but I feel sorry for people who have to use this software. And apparently it is the industry […]
If you’re not using more than one monitor, you are missing out big time. For one thing, some research by the University of Utah found that using two monitors increases productivity 44%. There’s a good summary and more comment on this on the coding horror blog. A huge benefit of multiple monitors for Macro Scheduler […]
A question arose in the forums the other day from someone looking at running some scripts for load testing and wanting advice on how best to run multiple instances of the same script. See the thread here for some useful ideas and links. I thought I’d summarise them here. An article on using Macro […]
An experienced Macro Scheduler scripter was recently trying to figure out why the following code wasn’t doing what he expected: If>seg_1=05 Let>monLtr=mm Endif Apparantly monLtr was always being set to 05. This told me that “mm” must have been a variable which had earlier been set to 05. But my friend said “I’ve looked […]
We recently received the following query to support: I’m interested in Macro Schedular for GUI testing. How do I verify that the test has succeeded or not? I thought it would be useful to post my response here: There are a number of ways you could do this. Which one you use might depend on […]