Macro Recording and Automating Windows with Macro Scheduler – Tips & News
Randy has just reported on his blog that the first run of his new Test Automation class which features Macro Scheduler in the hands-on exercises was a great success. The next class will be held next month in Rome, Italy on 16/17 June, where Randy will also be presenting a workshop entitled “Innovative Software Testing […]
When considering how to automate something, it’s often worth thinking about whether or not you can change the process a little first. An example that often comes up is the need to automate the retrieval and processing of a particular email message. Many people will already have a manual process that involves, not surprisingly, their […]
Someone asked me today how to run all macros found in a folder. This simple script will run all macros it finds in its own folder in turn: GetFileList>%SCRIPT_DIR%\*.scp,MacroFiles Separate>MacroFiles,;,Macros If>Macros_count>0 Let>k=0 Repeat>k Let>k=k+1 Let>this_macro=Macros_%k% If>this_macroSCRIPT_FILE Macro>this_macro Endif Until>k=Macros_count Endif Note the check to make sure it doesn’t run itself! This could be useful where […]
Here’s a quick and simple proof of concept for running Macro Scheduler macros via the web and having their output displayed in the user’s browser: 1) If you don’t already have a Windows based web server with PHP running, download and install WAMPServer. It’s easy. 2) Create a simple PHP script which takes an EXE […]
This is a variation of a question we get regularly. Usually it turns out that the script is waiting on a WaitWindowOpen line because of a typo in the window title. WaitWindowOpen, given a window title, will cause the script to wait until a window with that title exists. If you misspell the window title […]
Crumbs, is it really already December? Christmas always seems to creep up on me unprepared. Always so much to do and organise. Most people will be winding down and spending time with friends and family. But in our modern 24×7 culture many businesses still keep running. Web sites and servers still need monitoring, reports generating, […]
This morning, forum user hip asked how a script could sort a CSV file. Seems CSV files, sorting and Excel has become a bit of a hot topic here lately. Since Excel can read and save to CSV and also has a Sort function we might as well make use of it. Here’s a little […]
Earlier this month I wrote about how you can read and write data from/to CSV files as if they were database tables using DBQuery. Andrew asked if I knew of a way that XML files could be treated as database tables in the same way. I did find a couple of references to some ODBC […]
If you are automating web pages or web applications you may at some point need to automate dialog boxes produced by client side script, like the one that pops up when you click the link below: Confirm Popup So you might want to be aware that the title of these popups varies between different versions […]
Twice today, for two different people, I needed to write some code to iterate through files in a tree of subfolders. The subfolder structure could not be known up front and there may be any number of subfolders and any number of folders deep. One could use GetDirList iteratively, or use VBScript’s FileSystem Object. But […]