Category: Scripting

Detect Which Web Page IE Is On – Keep It Simple

August 8, 2014 by Marcus Tettmar in Automation, Scripting

Today we had two different support requests asking how to have a Macro Scheduler macro determine which page IE is on. One person was asking about using Image Recognition for that. You could also use the IE functions to examine the HTML or look for the existence of a specific HTML element. You could do […]

Read more »

Why doesn’t SHIFT-ESC stop my compiled macros?

March 27, 2014 by Marcus Tettmar in Automation, Scripting

You might find that when you run a compiled macro and you also have Macro Scheduler running, Shift-Esc – the default stop key sequence – doesn’t stop the compiled macro. This is because the stop key sequence is a system wide hot key. And system wide hot keys can only be registered for use by […]

Read more »

Recursion – Get A List of All Subfolders

March 18, 2014 by Marcus Tettmar in Scripting

Someone was asking how to get a list of subfolders. You can do that with the GetFileList command by setting GFL_TYPE to 1. That gives you the folders in the specified path. But it turns out he wanted a recursive list – i.e. one that drills down through all levels. To do that you need […]

Read more »

Reading from System Event Logs

February 11, 2014 by Marcus Tettmar in General, Scripting

Just been asked how to read from the system event log (what you see in Windows Event Viewer) using Macro Scheduler. As it happens there’s already an example of monitoring the event log for specific event types and responding to them in the Scripts n Tips forum here. So I’ve taken that code and modified […]

Read more »

Christmas Morning 1972 – Macro Scheduler Arcade – From JRL

December 27, 2013 by Marcus Tettmar in General, Scripting

Hope you all had a wonderful Christmas. I expect many of you are still enjoying some holiday time. Well if you are here’s some Macro Scheduler fun from forum regular JRL. Yes, it’s a two player 1970s computer game written entirely with Macro Scheduler code. Here’s the code See JRL’s forum post and grab the […]

Read more »

Print Excel File Automatically

December 10, 2013 by Marcus Tettmar in Macro Recorder, Scripting

Thanks to Alberto Voli for this little tip.  The code below can be used to print an Excel file without having to manipulate the printer dialogs.  It uses VBScript to interface with Excels’ COM object model to call it’s PrintOut method. Place the VBSTART .. VBEND lines near the top of your script ready for […]

Read more »

Making your macros intelligent with If, Else, and Endif

October 24, 2013 by Dorian in Scripting

I’m often asked how to make a macro behave differently based on certain criteria. The power and flexibility of Macro Scheduler makes this an easy task. There are hundreds of different reasons you might want to do this.  Maybe it’s dependent on : The answer to a question. The success/failure of an operation. The contents […]

Read more »

Automating Google

October 3, 2013 by Marcus Tettmar in Automation, Scripting

This has come up a few times lately so I thought I’d post it here. One or two people have been asking about writing a Macro Scheduler script that performs a Google search and pulls back the resulting URLs. They have discovered that trying to automate Google can be awkward because of the dynamic nature […]

Read more »