Macro Recording and Automating Windows with Macro Scheduler – Tips & News
If you have macros in Microsoft Word, Excel or Access they will be written in VBA – Visual Basic for Applications. If you wish to use this code inside Macro Scheduler you can convert this code to VBScript. However you cannot just copy the code and paste it into Macro Scheduler – or even into […]
UPDATE: 25/09/2012 – Macro Scheduler now includes some native Excel functions (XLOpen, XLGetCell, XLSetCell) etc. DDE is also no longer supported in the latest version of Excel. Using DBQuery, as described here, is still a very useful way to retrieve Excel data, especially for doing SQL style lookups. Last July I wrote this post summarising […]
Macro Scheduler 10.1 includes four functions for connecting to databases, querying and modifying data: DBConnect DBQuery DBExec DBClose Connecting to a Database Before you can connect to a database you’ll need to make sure you have the required OLE DB/ODBC drivers installed. You can see what drivers are already installed under Control Panel > Administrative […]
A WebRecorder (GUI: 2.02, DLL: 2.01) update is available. This version adds: – Refresh command, to refresh the browser – For check boxes ExtractTag will now append :CHECKED to returned value if the checkbox is checked. Evaluation Downloads | Registered Udates | Info
Macro Scheduler 10.1 has been released. This update includes some minor fixes as well as some bonus new features. We’ve added native database functions to make it easier to retrieve and modify data from SQL data sources and remove the need to use VBScript/ADO. This version also adds more script triggers. The window event option […]
Dick Lockey has written a nice example in Scripts ‘n Tips showing a good use of the Include statement. Include allows you to include other scripts in your code. A good use of this is to keep commonly used subroutines, VBScript code, or dialogs in scripts that you can then Include in your macros, rather […]
It is now possible to search the entire mjtnet.com site with Google:
Common questions we receive are things like “What’s the best way to learn more about Macro Scheduler?”, or “How can I advance my Macro Scheduler skills?”. You may be just getting started, or you may be wondering whether you can improve one of your scripts or how to tackle another process. There are a number […]
The purpose of embedding a file into a Macro Scheduler script is to be able to have a script use that file on a computer that might not have the file or that the file is in an unknown location. For example a spreadsheet or database file could be embedded so that the script could […]
I posted a link to a list of system error codes before. But I recently found this handy little utility which gives you a quick way to look up a Windows error code and find out what it means. Good to have on your desktop.