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 […]
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 […]
I’m often asked how you can run Macro Scheduler macros from other programming languages, particularly VB. Macro Scheduler scripts can be run from the command line. See the help file topic “Command Line Options”. E.g.: msched.exe “c:\someplace\mymacro.scp” VB/VBA lets you execute external commands/applications via the Shell function: Shell “””c:\program files\macro scheduler 11\msched.exe”” “”c:\scripts\example.scp”””, vbNormalFocus […]
I just posted a script to the Scripts ‘n Tips forum with a function to perform an HTTP file upload.
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 […]
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 […]
I recently stumbled upon this series of video tutorials on Regular Expressions: Regular Expressions for Dummies If you want to know how to get some power of out of Macro Scheduler‘s new RegEx function you might find the above free video tutorial useful. One resource seen in the video that I didn’t know about is […]
Way back in the deep and distant past when the Internet was new and Bill Gates thought it was just a passing fad, I remember reading about a Cola vending machine on a University campus that some frivolous young boffins hooked up to the ‘net so that you could check its inventory from anywhere in […]
Macro Scheduler‘s LibFunc command allows you to run functions contained inside DLLs. A DLL, or Dynamic Link Library, is a file which contains functions that other programs can use. Windows includes a number of DLLs containing lots of functions that make Windows tick, and other applications are able to call them. These functions are known as the Windows […]