Macro Recording and Automating Windows with Macro Scheduler – Tips & News
Many support requests and forum posts I see include a script snippet and a statement like “this value is wrong” or “the if statement says false but it should be true”. So we make an intelligent guess and say “so perhaps the value you are comparing isn’t what you think it is. Use the debugger”. […]
Here’s a little script I wrote to give you a Date Picker dialog. Useful if you need to ask the user to select a date and want to make it easy for the user and avoid too much validation.
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 […]
Looping through a text file is commonly achieved with the ReadLn command in a loop, like the example in the help file: Let>k=1 Label>start ReadLn>c:\\\temp\\\test.txt,k,line If>line=##EOF##,finish MessageModal>line Let>k=k+1 Goto>start Label>finish This uses a very simple loop and loops through the file one line at a time using the ReadLn command and a counter variable. An […]
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 […]
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, […]
What is Image Recognition? Update. Image Recognition has been vastly improved and simplified since this article was written and in v13 we introduced an Image Recognition Code Wizard. Watch this video to see how simple it is. Image Recognition allows Macro Scheduler to find a bitmap (needle) in another, larger, bitmap (haystack) and return its […]
To run WebRecorder, or VBScript macros which automate Internet Explorer in Vista (IE7), you will first need to disable “Protected Mode”. Consider this simple VBScript code: Dim IE Set IE = CreateObject(“InternetExplorer.Application”) IE.Visible=1 IE.Navigate “http://www.mjtnet.com” In IE6 and in IE7 under XP this code would create a new IE instance and then navigate it to […]
I’ve just posted a tip to Scripts ‘n Tips showing a simple Bubble Sort subroutine. The example sorts a list of files returned by the GetFileList function. I hope it’s useful. Here it is.