Date Picker Dialog
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.
Category: Scripting
Keep it Simple – Shortcuts and Applications
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 […]
Methods for Accessing Excel Data
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 […]
Reading through text files in memory
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 […]
Office 2007 VBA Shell Bug?
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 […]
First Winner of Scripts & Tips Competition
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, […]
How to Use Image Recognition
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 […]
Web Automation in Vista
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 […]
Sorting Bubbles
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.
Get Selected Tab Index
As you probably already know, selecting a page of a tab control is usually best achieved by sending CTRL-TAB. So on opening an application we can use the following Macro Scheduler code to jump to the third tab: SetFocus>Window_Title Press CTRL Press Tab * 2 Release CTRL This issues CTRL-TAB twice and therefore cycles through […]