Do you know what code signing is?
Want to prevent those “unknown publisher” warnings that might pop up when you or your clients download and run your compiled macros?
Then you need a Code Signing Certificate to sign your .EXEs with.
It’s not always when downloading files that you might get this warning. Recently a customer found a .EXE that he was launching from a reporting tool was producing this warning. It seems the reporting tool was checking for a code signing signature. Virus checkers including Windows 8′s SmartScreen filter will also look upon signed apps more favourably.
In forum post “Is it a Macro Recorder, is it an Automation Tool, or ….” Antonius asks how we can make Macro Scheduler more popular. This is not the first time I’ve been asked this.
The easiest and quickest way to help is to Share. At the top right of every page of the website are some “Social Sharing” buttons.
Click on your favourite social networking site (e.g. Facebook, Twitter or Google+) to share www.mjtnet.com with your followers. Click the +Share link to get a list of other places you can share to.
Or you can use this link here:
Clearly we’d LOVE it if you shared. All businesses, especially small ones, need new customers. But apart from that we want to build the user community for the benefit of everyone. More users means more forum peers, more product ideas and an even better Macro Scheduler. So, go on, get sharing
Just been asked how to read from the system event log (what you see in Windows Event Viewer) using Macro Scheduler.
So I’ve taken that code and modified it slightly to return a list of all entries for a given event code. Here is the script:
Although I’ve added code to allow you to retrieve ALL events I would not advise it as that could take A. VERY. LONG. TIME.
When you tell people about Macro Scheduler how do you describe it? Do you call it an automation tool, a macro recorder, a script language, a data entry tool, an interface builder, a trained monkey, or something else altogether?
I’d be interested to know.
To me Macro Recorder suggests only a tiny part of its capabilities, but it’s a useful and popular term.
An automation tool sounds more encompassing but “automation” can mean different things to different people.
IBM and SAP use “automation” to refer to the interconnected nature of their Enterprise solutions, connecting data across the entire organisation. But to me – and Macro Scheduler – automation is something more robotic: automation of a more specific set of human activities.
This kind of automation requires a tool box containing many tools, one of which might be the macro recorder.
Does it matter? Not if you’re using it and benefiting from it, no, probably not. But in getting the word out, explaining what it is to people and from a marketing point of view, it’s more tricky.
Happy New Year everyone!
Apologies it’s a bit late. Our family Christmas and New Year was pretty full on and then just as things were meant to go back to “normal” I went down with tonsillitis. Seems something like this is going around these parts and I’m not the first. So that pretty much put me out of action for the first part of this week.
But happy to say I’m much better now and back to full speed ahead.
Over here in the UK it’s currently very, very, very wet. Floods all over the place. In the US it looks like it is very, very cold. Hope wherever you are you are safe and sound and looking forward to everything 2014 has to offer.
Cheers for now!
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 code here: http://www.mjtnet.com/usergroup/christmas-morning-1972-t8106.html
Paste it into a new Macro Scheduler macro, hit run and off you go. Up and down arrows control the right hand paddle, A/Z the left. Enter to start, Esc to end. Happy Memories! Enjoy
If you don’t have Macro Scheduler you can download a trial version here.
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 use. To use modify the path to the Excel file in the VBRun line and place that line where needed.
You can use this approach with other Microsoft Office Apps, e.g. Word. A good tip is to record a macro within Excel or Word using it’s own macro recorder. This will create VBA code. You can then view the VBA code to figure out what objects and methods you need. You can then convert it to VBScript which you can run inside Macro Scheduler.
Get 25% off new Macro Scheduler licenses until the end of this month.
For the rest of December 2013 we’re offering 25% off all new license sales. Just use the following coupon code:
This code is valid for all editions of Macro Scheduler and can be redeemed at http://www.mjtnet.com/pricing.htm (Enter the code on the cart/checkout page).