ItLocation Review
Looking at our referrer logs it seems we get quite a few visitors linking through from our listing at: http://www.itlocation.com/en/software/prd46729,,.htm But I notice there’s no user review yet. Care to add one?
Archive: July 2007
Macro Scheduler Needs a Home on Wikipedia
Wikipedia lacks a “Macro Scheduler” page. It should be neutral (i.e. not written by me). Anyone can create one. Want to start it? Go to: http://en.wikipedia.org/wiki/Macro_Scheduler and get stuck in. Anyone can contribute.
Dutch Translation and Website
Many thanks to Ferry Halekor for successfully translating Macro Scheduler to Dutch. He’s now about half way through translating the help file. Ferry has also made a Dutch website especially for Macro Scheduler. If you read Dutch, check it out.
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, […]
Post to Scripts & Tips and Win Free Upgrades
We’re running a competition where you can win your next upgrade free if a script you submit is chosen for inclusion in the Scripts & Tips archive. We’re looking for useful scripts and examples which can be added to the Scripts & Tips archive and will benefit others. Any scripts that are accepted for inclusion […]
Celebrations All Round
So a day after celebrating our 10th anniversary I’m pleased to also congratulate Nagarsoft on their 1st year in business. Nagarsoft have achieved much in their first year, with the launch of their superbly crafted Direct Access: Direct Access speeds up your personal computing experience by reducing time consuming, repetitive tasks through the use of […]
Macro Scheduler 10 Year Anniversary Offer on Bits du Jour!
Today, 1st May 2007, Macro Scheduler is on sale at Bits du Jour. Ten years ago on 1st May 1997 we sold our very first copy of Macro Scheduler. Back then there was only one edition of Macro Scheduler and it sold for just $40. Today, for one day only, you can buy the latest […]