Posts by admin:

    How to convert Excel xlsx to xls with Automator with Office 2016

    May 13th, 2017

    So, MS have removed Automator functions for Excel 2016. Thanks.

    Note, my output filename is hardcoded because I use this file for printing labels with a Dymo Labelwriter that needs to know the filename before hand.

    Here’s my workaround:

    on run {input, parameters}

    set docFolder to path to documents folder as text
    set old_file_name to input as text
    set new_file_name to docFolder & "new-file.xls" as text

    tell application "Microsoft Excel"
    activate
    set theWorkbook to open workbook workbook file name old_file_name
    set theWorksheet to worksheet 1 of theWorkbook
    save as theWorksheet filename new_file_name file format Excel98to2004 file format with overwrite
    close active workbook

    end tell

    return docFolder
    end run

    No Comments "

    It’s been awhile…

    October 9th, 2014

    After my back injury, I’ve struggled to get active again. I’ve tried to start running again, swimming again and even walking again, but I can’t sustain any of those activities for long because my back just hurts too much.

    What I can do, though, is cycle. It’s been a busy time for us in the last few years with a major move to Wiltshire. I say major because I’d lived in my old house for 22 years so had A LOT of crap to get rid of. Then we had to start a full restoration on the new house. To that end, we only got back on our bikes a few months ago. And, in my own inimitable fashion, decided it would be huge fun to sign up for a sportive. Which I did. It’s this Saturday. It’s 54 miles long.My longest ride to date is 34 miles. Fortunately, the last 20 miles of Saturday’s ride is downhill.

    I’ll keep you posted.

    No Comments "