Marcus' Macro Blog

Tips and News on Macro Recording and Automating Windows with Macro Scheduler
April 19th, 2016 by Marcus Tettmar

Macro Scheduler Maintenance release 14.2.08 is now available for download.

Links: Version History | Registered Downloads | Trial Downloads | New Licenses

April 19th, 2016 by Marcus Tettmar

I’ve only just discovered that our newsletter subscriptions system has been broken since last January! New customers and anyone signing up to our newsletter since 15th January 2015 were not correctly subscribed to our newsletter. Luckily we have the email addresses in our database, they just weren’t allocated to the correct list. I’ve now fixed this and moved affected email addresses to the correct list. So those affected will now start receiving our newsletters. Hopefully you won’t be too surprised when you start receiving newsletters from us.

February 11th, 2016 by Marcus Tettmar

Macro Scheduler Maintenance release 14.2.07 is now available for download.

Links: Version History | Registered Downloads | Trial Downloads | New Licenses

January 13th, 2016 by Marcus Tettmar

A slightly belated Happy New Year to all our customers and supporters. I’m a little late getting this up as we are in the midst of an office move! So things are a little hectic.

But wanted to say thank you to you all for being with us and we look forward to working with you in 2016 and beyond!

December 10th, 2015 by Marcus Tettmar

I am pleased to announce that Macro Scheduler maintenance update 14.2.06 is now available.

Links: Version History | Registered Downloads | Trial Downloads | New Licenses

December 10th, 2015 by Marcus Tettmar

You may already be familiar with the Macro Scheduler debugger and know how to set code breakpoints. But did you know you can set variable breakpoints too? With a variable breakpoint you can cause execution to pause when a specified variable becomes equal to a given value.

You will find the “Variable Breakpoints” option under the “Debug” menu in the code editor.

You can set one or more variables and values. Then at any point during execution when one of those conditions occurs the macro will pause and allow you to debug.

This can be very useful when you are not sure where an issue is occurring but you may know that a specific set of data causes a problem that you want to debug.

November 27th, 2015 by Marcus Tettmar

So it’s Black Friday. Sounds so gloomy. A day where many appear to go mad and gorge.

There’ll be no extra discounts from us today, but what we will do is donate 10% of today’s sales to The Woodland Trust and St Mungo’s charity for the homeless.

So if you buy or upgrade Macro Scheduler today, or renew your maintenance you’ll be planting some much needed trees and providing for people who really need stuff. :-)

November 24th, 2015 by Marcus Tettmar

If you’re new to automating IE/websites with WebRecorder or the native Macro Scheduler IE functions you may be wondering how to determine which elements and attributes to use.

In this video I demonstrate how to use IE’s F12 key to invoke Developer Tools and use that to quickly find the elements we’re interested in and the attributes we need to use:

(You might want to click on the video toolbar to select a larger resolution size, view full screen or view on YouTube so that you can see the code).

November 13th, 2015 by Marcus Tettmar

Thanks again to Chris Henwood for designing another stunning livery. This time for this virtual Aussie V8 Dorian is driving in Forza Motorsport:

Aussie V8 with MJT Livery

Dorian is racing this car twice a week. Good luck Dorian!

November 11th, 2015 by Marcus Tettmar

Macro Scheduler‘s ReadFile and ReadLn functions understand ANSI, UTF8 and Unicode files – as long as they have a valid BOM header.  But a client recently needed to read in a file with a missing BOM.  So we wrote a little bit of VBScript which reads the binary stream in, and then outputs a UTF8 encoded file.  

Here’s the code:

VBSTART
Sub UTFConvert(filename)
  Set fso = CreateObject("Scripting.FileSystemObject")
  txt = fso.OpenTextFile(filename, 1, False, -1).ReadAll
  Set stream = CreateObject("ADODB.Stream")
  stream.Open
  stream.Type     = 2 'text
  stream.Position = 0
  stream.Charset  = "utf-8"
  stream.WriteText txt
  stream.SaveToFile filename, 2
  stream.Close
End Sub
VBEND

//Convert it to UTF8
VBRun>UTFConvert,%SCRIPT_DIR%\data.txt

//Now we can read it :-)
ReadFile>%SCRIPT_DIR%\data.txt,theFileData

      Archives

  • Categories