Category: Automation

Capturing Screen Text

December 12, 2007 by Marcus Tettmar in Automation, Scripting

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, […]

Read more »

EXEs and Hotkeys

November 20, 2007 by Marcus Tettmar in Automation, Scripting

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 […]

Read more »

Application and System Monitoring

November 18, 2007 by Marcus Tettmar in Automation, Scripting

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 […]

Read more »

Screen OCR to Retrieve Otherwise Undetectable Text

October 8, 2007 by Marcus Tettmar in Automation, Scripting

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 […]

Read more »

WebRecorder Update

September 18, 2007 by Marcus Tettmar in Announcements, Automation

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 […]

Read more »

Keep it Simple – Shortcuts and Applications

August 7, 2007 by Marcus Tettmar in Automation, Scripting

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 […]

Read more »

Methods for Accessing Excel Data

July 2, 2007 by Marcus Tettmar in Automation, Scripting

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 […]

Read more »

Office 2007 VBA Shell Bug?

June 27, 2007 by Marcus Tettmar in Automation, Scripting

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 […]

Read more »

First Winner of Scripts & Tips Competition

May 18, 2007 by Marcus Tettmar in Announcements, Automation, Scripting

We have our first successful entry to the Scripts & Tips 10 Year Anniversary Competition. Robert White sent in this excellent Cookie Monitor script. It’s a nicely written script which is both very useful and also demonstrates effective use of a non-modal dialog and other scripting features such as looping, reading a list of files, […]

Read more »

Remote Citrix Automation the Easy Way with AppNavigator

February 23, 2007 by Marcus Tettmar in Automation

In my last post I showed you how to write an Image Recognition script in Macro Scheduler to automate a remote Citrix session. I demonstrated how to use Image Recognition functions to look for screen objects and create an Outlook email. Well, in this demo I show you how to automate the exact same process […]

Read more »