matthew's blog

Resurrecting my "lost" Delicious bookmarks

If you used the Del.icio.us bookmarking website and accessed it via your Yahoo! account, you might well have lost access when the website was transferred to its new owners (i.e. if you didn't opt in to have your account transferred across). Read on to find out how I backed up my bookmarks and transferred them to a new service (Pinboard) even though the new Delicious.com wouldn't let me log in.

Simplicity in programming: a review of ACCU 2011

programming

I recently went to the ACCU 2011 conference, for programmers who believe in ‘professionalism in programming’. There was an eclectic programme of talks, but I was struck by how often the presenters had something interesting to say about one topic in particular: simplicity. Rather than write up the individual presentations, I thought it would be more interesting to write about what was said about simplicity.

Line spacing blocks of paragraphs in HTML with CSS

Suppose you have a note class in HTML. A note can have one or more paragraphs.

<p>This is not a note.</p>
<p class="note">This is the first line of a note.</p>
<p class="note">This is the second line of a note.</p>
<p>Back out of the note again.</p>

Here is a CSS snippet you can use if you want to add margins to separate the note from the surrounding text without affecting the line spacing of the note itself (and adds some sensible page breaking behaviour).

Preventing "Command Not Found" errors when changing Word's headers/footers in VBA

word2007

I found various threads on the Web from people complaining about Command Not Found errors when using macros that change Word's headers and footers.

I didn't find any solutions, but think I have an answer. Read on to find out more.

Tip: Clickable tables of contents when publishing to PDF from Word 2007

word2007

If you have a Word 2003 or earlier document with a table of contents, you might expect the ToC to behave as a series of hyperlinks when you save the document as PDF, so you can click an entry to jump to it.

If this doesn't happen (i.e. the ToC appears as plain text in the PDF), try editing the ToC so that Use hyperlinks instead of page numbers is on for the web view. Then when you publish to PDF you should find that the links work as expected.

Running Office applications as a service on Windows Server 2008

excelword

Having difficulty running Word or Excel as an unattended scheduled task on Windows Server 2008? Does the process keep dying? Here's a simple solution.

XSLT Gotchas

Not for the first time I've been caught out when trying to do simple XSLT to pick information out of XML files. Hopefully this is the last. I'm blogging this so I can refer to it again later. Hopefully it will be useful to you too.

Simple time logging in Excel

excelproductivity

Sometimes, when I'm working on a project, I need to keep stopping and starting. Although I've used various stopwatch programs in the past, these days I often just write down the start and end times of each batch of work and then work out the total later.

Read on for details of how I use Microsoft Excel to work out the total, even if I work over midnight.

When is a website not a website? When it's an app!

googleproductivity

I tend to work with lots of browser windows open, particularly when I am researching something. I don't see that as a problem in itself. What it a problem, however, is not being able to find a particular window that I know is open amid the noise of all the other browser windows.

Read on to find out my solution to this.

Creating Japanese HTML Help (chm) using Author-It

Japanese

I've been using Author-It v5.3.207.6063 to generate help in Japanese. This seemed to work fine, but the resultant chm file's Search tab wouldn't work with Japanese glyphs (only with English characters).

Further experimentation has revealed a way of getting the Search tab to work. I had to do the following:

  1. Update the regional settings (XP) to enable Japanese and set it as the default for non-Unicode applications
    1. On the Languages tab, tick “Install files for East Asian languages”
Syndicate content