December 11, 2006

Works with Vista – Official

Filed under: Vista — Marcus Tettmar @ 2:17 pm

Works with Windows Vista We’ve recently entered the Microsoft Windows Logo Program and just obtained the Works with Vista logo for Macro Scheduler 9.0 🙂

December 7, 2006

Mindless, illogical bureaucracy

Filed under: General — Marcus Tettmar @ 10:50 am

My sister and her partner are emigrating to New Zealand. Her partner went out there a few weeks ago. In order to ensure his legal and financial affairs could be easily dealt with he gave his mother power of attorney. So he gets to New Zealand and opens a bank account, then asks his mother to transfer some money from his UK bank account to his new NZ one. His mother goes to the bank to sort this out but is told that they can’t do it because they don’t know her – she’s not the account holder. But she has power of attorney. She shows them the power of attorney papers and demonstrates that all is in order legally. Nope they won’t budge. They won’t authorise the transfer. So she has an idea – can she transfer some money from her UK account to his NZ account instead? Yes, no problem. And, as power of attorney, can she transfer money from his UK account to her UK account? Yes, no problem. Ok, job done then. Seriously. I’m not making this up.

December 5, 2006

Web Automation in Vista

Filed under: Announcements,Automation,Scripting,Vista — Marcus Tettmar @ 1:51 pm

To run WebRecorder, or VBScript macros which automate Internet Explorer in Vista (IE7), you will first need to disable “Protected Mode”. Consider this simple VBScript code:

Dim IE
Set IE = CreateObject(“InternetExplorer.Application”)
IE.Visible=1
IE.Navigate “http://www.mjtnet.com”

In IE6 and in IE7 under XP this code would create a new IE instance and then navigate it to mjtnet.com. But Vista adds something to IE called “Protected Mode” and for some reason Protected Mode causes the Navigate method to open up a new IE window. This is most annoying because it means any subsequent code in a script like the one above would fail because IE object refers to the instance created with the CreateObject call, but the page is now in the second instance.

You can disable “Protected Mode” in IE under Tools/Internet Options/Security. This puts things back to normal and means code like the above will continue to work.

One known issue with WebRecorder’s IEAuto.DLL is that the WaitNewIE function hangs when using IE7. We’re working on this now. This function is only used when an action in IE causes a new window/tab to appear. Apart from that, once you have disabled “Protected Mode” WebRecorder/IEAuto works fine with IE7/Vista.

Update: Version 1.78 is now available, fixing the issue with WaitNewIE on IE7.

December 4, 2006

Running Legacy Apps Under Vista

Filed under: Vista — Marcus Tettmar @ 3:31 pm

If you’re thinking about upgrading to Vista and want to know if your favourite apps will run, here’s a very simple test to try first. In XP create a standard, restricted user account. Now try and run your apps. If they fail to run, or pop up access denied errors when trying to save data or settings, then they will very likely have similar issues when running under a default Vista install.

With previous versions of Windows the default account was always an administrator. If you’ve installed XP out of the box you are probably running as admin. And every application you start has administrator privileges. This means it can do things like write to the Program Files directory, or HKLM, etc. Because this is default, software developers have got into a bad habit of assuming that the user is an administrator. Believe it or not there are developers out there who don’t even realise there’s a different kind of user, and have never tested their software under a restricted user account. Until now this hasn’t been much of an issue because the vast majority of users are administrators anyway.

But with Vista things have changed, for the better. Now, while the default user account is still the Administrator account, all applications run at least user privileges. Applications that require administrator privileges to run, e.g. system configuration tools, can be marked as such and when started will prompt the user to ask permission to continue. This means that the user now knows when an app is about to do something that requires admin rights. If the user is not an administrator she can ask the admin to come and enter his/her password and allow the administrative function to proceed. Or not. This new approach will cut down on malicious programs, trojans and viruses etc, because a process that needs to make a system change cannot do so invisibly. If the process is not marked as requiring Admin privileges, it will not be able to perform administrative tasks. If it is marked, it will pop up a confirmation box.

So lots of applications you have been using happily on XP may be assuming that you are an Administrator. And you may find when you try to run them on Vista that they fail to work. Perhaps because they try to store settings in HKLM or Program Files. If the application lets you change the folder it uses to store settings and output files, change it to a folder in your personal Documents folder.

If you can’t change the fact that it needs to write to a privileged location, and assuming you are logged in as Administrator, one workaround is to run the app with Admin privs. Right click on the application and select “Run as administrator”. Or modify the shortcut. Right click on your shortcut, select Properties then Compatibility and check the “Run this program as administrator” option. But please only do this for applications you trust! Don’t go and give any old application administrative privileges, or you defeat the purpose of this new security feature. Likewise, please don’t disable UAC (User Account Control) altogether.

I’m running a small number of tools that I have to do this for. For now I’m running them as Admin. But I hope the developers will issue updates soon so that I can run them more cleanly under Vista. Reading through various developer groups that I’m a member of I’m constantly amazed at how many developers only just seem to be thinking about Vista, and seem to be confused about these simple changes. Yet Vista has already been released to businesses and has been in beta for the best part of a year.

November 28, 2006

Free Copies of Vista and Office 2007!

Filed under: Vista — Marcus Tettmar @ 9:52 pm

But only if you’re in the USA. If you are, you might want to check this out: http://www.powertogether.com/. According to this you just have to watch three webcasts on each product within 30 days of registering and Microsoft will send you Vista Business and Office 2007 Pro, for free!

November 25, 2006

Running Vista

Filed under: General,Vista — Marcus Tettmar @ 10:51 pm

So I downloaded the final version of Vista last week and I’m now running Vista as my main environment. Am I mad? Let’s see how it goes. Lots of my favourite apps need to be run as admin because they write to the programs folder, or HKLM. For years, developers have made the bad habit of assuming the user is admin due to the way previous versions of Windows install by default. But with Vista defaulting to run apps at least user privileges, all that will have to change. But until these legacy apps get updated or replaced, there will be lots of workarounds. And I wouldn’t be surprised if many people switch off the new security features of Vista in order to run their old apps, and in so doing defeat the purpose of the main focus of this new operating system! Time will tell. Of course, Macro Scheduler is already Vista compliant and v9.0 has been built with Vista in mind, so no problems there.

I’ve already found what appears to be a bug in the final release. Vista wouldn’t let me attach to a network printer, shared by an XP machine. It kept saying access denied. Yet I was able to add the printer driver manually under LPT1 and then change the port to the network name of the shared printer. Then everything worked. Go figure.

Since RC1 I’ve been baffled by the shutdown options. And it seems I’m not alone. Why are there so many ways to switch off Vista, and what does the off button do that’s different to the six shutdown menu options? Do I want to lock/log off/switch user/switch off/restart or sleep!? Maybe I’ll just leave it running and not touch anything! Seems this is a result of design by committee and corporate bureaucracy.

November 20, 2006

MD5/SHA1 Hash DLL

Filed under: Announcements — Marcus Tettmar @ 5:02 pm

I’ve just uploaded a new Macro Scheduler MD5/SHA1 hash library to the libraries and plugins page. If you ever wanted a macro to verify the MD5 or SHA1 checksum of files, or need to hash strings, you can now use this DLL. Download it here.

November 16, 2006

Sorting Bubbles

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

I’ve just posted a tip to Scripts ‘n Tips showing a simple Bubble Sort subroutine. The example sorts a list of files returned by the GetFileList function. I hope it’s useful. Here it is.

November 15, 2006

QuickButtons One Day Sale

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

Scoop: QuickButtons will be on Bits du Jour next Monday (20th November) with a one-day 50% discount! Less than $10!? We must be mad.

November 13, 2006

Success Story – Advent Capital Management

Filed under: Success Stories — Marcus Tettmar @ 10:21 pm

By Ashley Henry.

My name is Ashley Henry; I’m a Network Admin at Advent Capital Management, which is a hedge fund managing billions of dollars. We deal nationally as well as internationally. There are several reports and processes that need to run several times per day; most of which require several redundant manual inputs. There’s never enough time in the day to complete most of the tasks the various departments need to get done. The challenge was to quickly and accurately transfer and print the data from various reports and processes to our trade system and with little or no manual intervention.

I’ve been using Macro Scheduler for about four months, Prior to using Macro Scheduler we attempted to print and enter these orders manually. This was very time consuming and error prone. It also cost more man hours than necessary. Since the Traders and Operations group are often interrupted by other phone calls and tasks, they would sometimes forget which report to run or when to run them.

Before coming to Macro Scheduler my programming / macro skills were minimal. I’ve primarily worked on the networking side of things. Since I had minimal experience in programming I thought that Macro Scheduler would be difficult to use, but I was pleasantly surprised. Marcus has been extremely helpful with some of the scripts that I couldn’t figure out. I’ve made hundreds of support calls to other companies and NONE has come close to the support that I’ve received from MJT. Thus far, I’ve saved the company at least 10 man hours per week and there’s so much more automating that needs to be done… Good job to Marcus for the wonderful product that he has produced.

Older Posts »