Automatically numbering many identical documents in Word with a little help from VBA

So, come in to work today and I am asked to produce 83 Exhibit Note Certificates. 83. I cannot palm this off because the admin assistant is off sick with the flu, and I cannot push the task back any further because the affidavit and its exhibits are due today. I’m going to be busy enough engrossing and witnessing the affidavit, sorting out the actual exhibits, and certifying each Exhibit Note. So I think, what is the quickest way of producing these documents? It’s for New South Wales, and unlike here, I don’t actually have to describe each document on the face of each Exhibit Note…the only variable then is the exhibit number…and guess what? Word has a perfectly good counter built into it. No, I am not talking about mail merge, but rather Visual Basic for Applications. Going off memory the process is to:- draft a model exhibit note certificate, with the date filled and my details filled in use insert two Document Variables, “ExhibitNo” and “ExhibitNoDup” , where

Continue Reading...
May 25th, 2010

Using SSH in Bash to tunnel IP traffic

While it is trivial to set up locally forward ports using a GUI SSH client like Putty, I have a habit of forgetting how to do the same at the Bash command line, and I find the ssh man page a tad confusing. Cutting straight to the chase:- $ ssh -X myserver.dyndns.org -p 1045 -L 10001:192.168.0.100:10000 This will connect to server called “myserver.dyndns.org” on arbitrary external port 1045, and map your localhost port 10001 to port 10000 on the machine with IP address 192.168.0.100 on the remote site (allowing you, for instance to access Webmin on the remote machine by going to https://localhost:10001 ). The tack “-X” tells SSH to forward X11 requests, allowing you to run GUI applications on the remote machine and have the display on your local machine without further configuration in a Linux environment, or after installing a program like Cygwin on a Windows machine.

Continue Reading...
May 21st, 2010

Site reboot

My first post explaining the rationale behind rebooting this site.

Continue Reading...
May 19th, 2010
Contact Nixz Kerr