Category: Scripting

Calling Macro Scheduler Scripts from VB/VBA

June 4, 2009 by Marcus Tettmar in General, Scripting

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

Read more »

Multiple Monitors aid Productivity and Debugging

May 19, 2009 by Marcus Tettmar in Automation, General, Scripting

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

Read more »

The Variable Explorer

May 12, 2009 by Marcus Tettmar in Automation, General, Scripting

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

Read more »

Regular Expressions for Dummies

April 30, 2009 by Marcus Tettmar in General, Scripting

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

Read more »

Twittering from Macro Scheduler with the Twitter API

April 20, 2009 by Marcus Tettmar in Scripting, Web/Tech

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

Read more »

Working with Windows API Functions

April 17, 2009 by Marcus Tettmar in Scripting

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

Read more »

We can Automate Your Task

April 13, 2009 by Marcus Tettmar in Announcements, Automation, Scripting

We don’t just sell great automation software.  We can also build your task for you. If you don’t have the time, know-how or technical resource to automate your task yourself you might want to check out our new We Can Build It service. We’ve been doing custom script development for years but have never actively […]

Read more »

IsNumeric: More fun with Easy Patterns

March 12, 2009 by Marcus Tettmar in Scripting

VBScript has a function called IsNumeric, but as discussed in this forum post VBScript numbers can contain the letter ‘E’ (and it would seem ‘D’ too). These are valid numbers as far as VBScript is concerned but in the real world we usually don’t care for them. Numbers may also be floats. So in the […]

Read more »

Reading from CSV Files

by Marcus Tettmar in Scripting

An interesting discussion arose in the forums yesterday on how to read data from a CSV file. The usual suggestion is to use Separate to split each line into an array using the comma as the delimiter, as explained in my post here. The problem, as highlighted in the forum topic, is: what if the […]

Read more »