Macro Recording and Automating Windows with Macro Scheduler – Tips & News
By now you are probably aware of UAC (User Account Control) that came along when Vista was released. And you probably know that to do anything like copy files to Windows\System32 or Program Files or do other administrative stuff you need to be running as Admin, or you’ll get the UAC prompt come up asking […]
It occurred to me the other day while working on a script for a customer that I use this regular expression frequently: (?<=TOKEN1).*?(?=TOKEN2) It is very useful when parsing information out of web pages, or when finding elements in web pages. What it does is pull out all the text between TOKEN1 and TOKEN2. Those […]
Since version 13.2 Macro Scheduler‘s email functions now support SSL. Google’s Gmail and many other email services now insist on SSL secured connections. To use SSL you first need to install the OpenSSL library files. Here’s an example of sending an email via Gmail: Let>SMTP_AUTH=1 Let>[email protected] Let>SMTP_PASSWORD=your_password Let>SMTP_PORT=465 Let>SMTP_SSL=1 SMTPSendMail>[email protected],smtp.gmail.com,[email protected],your name,test,hello world, And to retrieve […]
I recently wrote a small macro for a customer which does an HTTPRequest via SSL. This requires that OpenSSL is installed. But the customer wanted to know if there was any way of distributing the macro to his users without having to install OpenSSL on all their PCs. Thanks to our wonderful forums one of […]
Can you send keystrokes to invisible or unfocused windows? The answer is yes, if the control you want to send the keystrokes into is a “windowed control”. That is, one that has a handle. If that’s too technical just try using the “Send Keys to Object Wizard” in Macro Scheduler 13 which generates code that […]
We have today released WebRecorder 3.0. This is a major rewrite with a better recording engine capable of recording more tags and producing leaner, cleaner, code and a faster and more reliable runtime. It also introduces a download manager so that file downloads can be recorded and scripted more easily without recourse to sending keystrokes […]
I’ve seen quite a lot of requests lately from people wanting to know how to extract text from web pages. Macro Scheduler’s optional WebRecorder add-on simplifies the automation of web pages and includes functions for extracting tables, text or HTML from web page elements. WebRecorder’s Tag Extraction wizard makes it easy to create the code. […]
Macro Scheduler veteran John Brozycki has put together this fantastic video tutorial all about Macro Scheduler’s debugging capabilities. The video is 18 minutes long and demonstrates every debug feature, showing examples of their use and talks about how useful the debugger can be for problem resolution as well as script creation. Take a look: A […]
Macro Scheduler comes complete with some native functions for controlling Excel, such as XLOpen, XLGetCell, XLSetCell and others. Obviously, although we intend to add more functions over time, not every possible Excel function has been duplicated. So sometimes you may want to utilise COM via VBScript which allows you to access the entire Excel API. […]
Another contribution from Peter Begelsdorf which takes off from where his last video left off. Aimed at complete beginners this video demonstrates how to execute a file and wait for it to be ready before sending text and keystrokes to it. Part 1 of this sequence and other videos can be found on the Video […]