March 27, 2013

Getting Data From Excel Without Office Installed

Filed under: Automation, Scripting — Marcus Tettmar @ 11:00 am

In this post from 2008 I demonstrated how to get data from Excel worksheets using Macro Scheduler’s database functions.

This works fine if Office is already installed on the PC.   But what if you want to get data from an Excel sheet and the PC you are running on doesn’t have Office installed?

Well you need the Office Data Connectivity Components which you can download from microsoft.com here:

http://www.microsoft.com/en-us/download/details.aspx?id=23734

This will install the OLEDB/ODBC drivers which DBConnect can then use to make a connection to a workbook.  You can then use DBQuery to retrieve data from a sheet as shown previously.

March 26, 2013

Announcing Script of The Month Contest

Filed under: Announcements — Marcus Tettmar @ 11:30 am

Each month we will choose our favourite script or video posted to the forums and send the developer an MJT Net Gearhead mug. *

Your entry may be something submitted in the usual course of events – i.e. as an example or in response to a user’s question, or just because you want to win a nice mug! 🙂

We’ll accept either some script code or a video demonstrating an automation routine running on your systems.

Any script code you submit needs to be something that will run anywhere and not dependent on applications that only you have access to!  If that isn’t possible, post a video instead.

Your script could be an example of some neat bit of code, something useful for others or just a bit of fun.  Ideally it will demonstrate something that others can learn from.

As mentioned, we’ll also accept a video or screencast if you have a cool script you want to share which only runs on your systems.  So, for example, if you have a routine running at work which automates a desktop or web app that can’t be shared, then take a screencast of the macro in action, submit it to youtube or vimeo or similar and post a link on the forum.

So, get your thinking caps on, and send in some cool code or a macro movie.

* Ideally, each month, we will choose a script/video posted the previous month, but we reserve the right to pick a post submitted at any other time (especially if there have been no recent entries).  We get to pick our favourite – whatever that may be 🙂

March 20, 2013

New Video Tutorials on Image Recognition, Arrays, Loops & Subroutines

Filed under: Announcements — Marcus Tettmar @ 9:12 am

Our good friend Antonius Momac has put together this great video tutorial series.

In this series Antonius walks us through how to use Image Recognition to find and click on a bunch of check boxes. As well as how to use Image Recognition, these videos show you how to loop through an array and how to create subroutines to make your code more efficient and reusable.

We have more video tutorials here. If you have an idea for a new video tutorial, please let us know.

March 14, 2013

Automating Ubuntu Desktop

Filed under: General — Marcus Tettmar @ 3:03 pm

Here’s a quick video showing how easy it is to use Macro Scheduler‘s image recognition to control a Linux Desktop (Ubuntu in this case):

March 12, 2013

January 31, 2013

Macro Scheduler 14 Is Here!

Filed under: Announcements — Marcus Tettmar @ 2:13 pm

After many months of development we are pleased to announce that Macro Scheduler 14 is now available.

There are lots of new improvements in this version and the full change list can be found here.

But here’s a summary of the main new features:

Improved Tolerant Portable Image Recognition Engine

This uses a clever pattern matching technology which means that rather than compare pixels exactly it can determine the similarity of images and, within a specified tolerance, determine the best match on the screen. What this means is that it will cope with subtle changes, e.g. between operating systems and program versions and between alterations to display settings.

Antonius made a great video of the image recognition features. Watch it here.

We’ve even tested finding a Save toolbar button on a modern UI where the capture was taken from an older style button on XP and was a different colour. The image matching technology was able to match the shape of the floppy disk on the button.

Improved Image Recognition Wizard And Easier Handling of Bitmaps

Alongside the image recognition engine we’ve overhauled the wizard so that you no longer have to give names to captures. The wizard creates a special folder named after the macro name where it keeps the images. Comments in the editor for each piece of code produced by the wizard show a thumbnail of the needle image so that you know exactly what each piece of code is looking for. There’s also an image explorer so that you can find sections of code based on needle images. And finally, when you compile your script the image folder is copied over to the .exe location making it easier to know what to distribute.

Native WebRecorder – Included

WebRecorder is now part of the core product. All the IE_ functions that were previously provided by the IEAuto import library are now regular native commands. This makes them easier to use (no need to set buffer lengths etc) and of course it also means that the documentation is all in the same place, and the new functions are included in the command locator with code builders.

WebRecorder is now included with Macro Scheduler Standard and Pro.

New Scheduler Features

We’ve added to the existing scheduling options the ability to specify any number of specific dates and times.

You can also set a macro to run on the 1st Monday of the month, or 3rd Wednesday of the month and so on. I call this the “nth nday of the month” option.

Previously to schedule on this basis you would have had to add some script code to determine if the date matches and set the script to schedule every day (or every Monday for example). Now you have finer control and it means less code.

New Native Zip Functions

Create zip files, add to zip files and extract from zip files. Simple.

New Hashing and AES Encryption

Create MD5/SHA1/SHA256 hashes and encrypt decrypt with AES.

New Online Manual

I’m already very proud of our help system and now it’s even better. We’ve done a lot of work to the manual and created a completely new online help system with comments.

The new online manual contains the exact same content as the help file that ships with the software [don’t worry – that is still there] but allows for extra dynamic content such as comments, questions and answers, tips and more examples.

Each page in the regular help file includes a link to the online version so that you can find more information or ask questions, or even provide your own tips.

Check out the new online manual here: http://www.mjtnet.com/manual/

And More …

  • IfNot functions (reverse of existing If.. functions)
  • New Script/Settings Backup Features
  • More Code Explorers
  • Modify variables during debug
  • Faster, improved macro search
  • New custom dialog grid control

See the complete change list here.

Downloads and Upgrades

Log into your account to view downloads/upgrades.

Those of you with current maintenance will already see v14 download links in your download account.

Anyone who purchased Macro Scheduler since 1st December 2012 have also been automatically upgraded to v14.

If you do not have maintenance and wish to upgrade you will find upgrade prices and links in your account.

Old Upgrade Pricing Maintained Until Feb 28th 2013

Our new license pricing has been increased. But for now we are keeping upgrade pricing at their old levels until February 28th. After that they will go up in line with the new license increases. So if you need to upgrade, do it before the end of February.

Maintenance Changes

We are moving to a 12 month maintenance package which includes all updates. The first year is included with new licenses and upgrades. When the maintenance period expires you can choose to renew for a further year.

Note: Existing maintenance plans will be honoured and will still run until the end of their period – if you already have maintenance then nothing has changed.

New Licenses

To purchase new licenses or for current pricing please go here.

January 24, 2013

Macro Scheduler Pricing Change – Beat It

Filed under: Announcements — Marcus Tettmar @ 3:24 pm

Just a heads-up that when version 14 is released our prices for new licenses will be going up.

BUT, those who buy, or have bought, Macro Scheduler within one month of v14 being released, will get v14 at no extra cost.

Therefore, if you are considering purchasing Macro Scheduler now, or thinking of getting additional licenses for your company, you might want to buy NOW to beat the price increase.

There is no need to wait until v14 is out. You’ll save money if you buy v13 now.

We will be keeping upgrade prices low for a while. So existing users will be able to benefit from the current upgrade prices.

Of course if you have maintenance you won’t need to do anything.

How to tell if the current session is a Remote Desktop session

Filed under: Automation, Scripting — Marcus Tettmar @ 10:51 am

Here’s a small piece of code which will tell you whether the current session is a Remote Desktop/Terminal Services session or not:

Let>SM_REMOTESESSION=4096
LibFunc>User32,GetSystemMetrics,isRemote,SM_REMOTESESSION
If>isRemote>0
    MessageModal>Current Session is RDP/Terminal Services Session
Else
    MessageModal>Current Session is Local Session
Endif

January 21, 2013

Why Don’t People Backup?

Filed under: General — Marcus Tettmar @ 5:10 pm

Every now and then someone will email us to let us know that they have overwritten one of their important scripts and now need to recover their old work. They write asking what we can do about it.

Well. Not much really. If the script wasn’t backed up and has been changed we can’t somehow get back the old version.

I’m always amazed at how few people seem to backup their work. Whether it’s a Macro Scheduler script or a Word document. Back it up.

Macro Scheduler stores scripts by default in a folder beneath the My Documents folder which is a default location for Windows Backup and other backup tools. So there’s not much excuse for not having a back up. Yet we meet people all the time who simply don’t back up.

For a while now Macro Scheduler has had a “Backup on Save” option which keeps the three most recent copies of scripts. But you have to switch it on.

And people still email us reporting lost data.

So with version 14 this Backup On Save option will be enabled by default. It will keep 5 copies by default and you can increase this number if you want. The main Macro Scheduler data files will also be backed up on startup.

I also recommend using source version control for important script projects.

January 18, 2013

Snow!

Filed under: General — Marcus Tettmar @ 8:43 am

Heaps of snow here this morning. Will be working from home today! My home office looks more like Santa’s Grotto: