Thanks so much for this! I've given it a try but haven't had any luck. Could be something that I'm doing (or not doing). This is what I've tried so far...

When I double click on it from my desktop, it opens and shows the field #0000. I opened the template again and the number hadn't increased. I wondered if I needed to save the document for the macro to work, but it still didn't work. Also I've tried 'running' the macro from the macro commands.

So I thought that maybe the template needed to be in the My Templates folder and moved it there. I opened a new document from template, and went through the same steps as above, but with no success. In fact when I tried to run the macro from this location, I got the following error...

Run-time error '-2147483640 (80000008)'
Method 'PrivateProfileString' of object 'System' failed

Next I wondered if it was either something to do with a setting on my computer, or that I'm using a mac. So I tried the template from our PC (from the desktop though). This hasn't worked either.

What am I doing wrong?