Macro Recording and Automating Windows with Macro Scheduler – Tips & News
The editorial comment in the latest issue of Computing magazine discusses how IT may hold the key to preventing a recession: “Financial institutions are looking for IT-enabled efficiency to help them through a sticky patch” Regular Macro Scheduler users don’t need to be told how much automation can boost productivity and increase efficiency. Just look […]
In this post I discussed the Text Capture commands and explained what kind of text can be captured. To try out the text capture functionality launch the latest version of Macro Scheduler. Click New to create a new script and then in the Code Builder locate the “Text Capture Wizard”. Point the mouse at some […]
As I have mentioned previously, Macro Scheduler 10 introduces some powerful new commands for capturing screen text. In this post I aim to explain what kinds of text can be captured with these new commands and why there will always be some text that cannot be retrieved. First let’s look at how the existing functions, […]
Something that comes up now and then is whether or not compiled Macro Scheduler macros can respond to hot-keys. Macro Scheduler itself lets you assign system-wide hot-keys to macros so that when you hit that key combination, no matter where you are in Windows, the macro will be fired. Some people want to be able […]
A short roundup of resources and ideas for using Macro Scheduler for system and software monitoring. Event Log Monitoring Here’s a tip showing how to create a script to monitor event log messages: http://www.mjtnet.com/usergroup/viewtopic.php?t=4256 Process/Service Monitoring This script demonstrates a function called IsProcessRunning to check if a specific process is running. Use it to create […]
Some while ago I wrote this post about how to script a tool called Textract to perform OCR against the screen. Well gpulawski has just posted this tip in the forums pointing out that Microsoft Office 2003/2007 comes with something called MODI (Microsoft Office Document Imaging) which can OCR a bitmap or TIFF file and […]
Today we have released an update to WebRecorder: WebRecorder GUI: 1.73 IEAuto.DLL: 1.79 Fixed: ContainsText unable to access content of some frames Fixed: ExtractTag unable to access content of some frames This update also correctly reports the version number of the WebRecorder GUI and the IEAuto.DLL version number. It now therefore works better with the […]
We had a customer email us the other day having a problem getting his macro to work reliably. He wanted to start an application, so he had written a macro to left click on the application’s shortcut on the desktop. But sometimes the icon moved. He wanted to know how to reliably know where the […]
UPDATE: 25/09/2012 – This article was written in 2007 before Macro Scheduler contained native Excel functions and native database access. Furthermore, since this article was written Excel no longer supports DDE. This article has therefore been superseded and should only be used as a reference for use with older versions of Macro Scheduler and/or older […]
When trying to execute a third party application, such as Macro Scheduler, from VBA in Office 2007 using the Shell function the following error is returned: “Invalid procedure call or argument” Sometimes you might want to run a Macro Scheduler macro from Office using this method and get this error. Searching the web reveals many […]