Tag Archives: automation

Just a short post to add another AppleScript snippet some might find useful. (There will be performance-related posts along shortly; I have some in the works.) As you know from previous posts under the tag topics, I’m automating as much of my Excel use as possible. So here’s a short snippet of AppleScript to setContinue reading “Setting Axis Font Sizes In Excel With AppleScript”

In Excel – Sorted With AppleScript I mentioned I might have a go at transposing rows and columns in an Excel spreadsheet with AppleScript. I said there were two things I could try – each with a different use case: Transposing Rows And Columns In A Spreadsheet Transposing Rows And Columns In A Graph IContinue reading “Excel – Two Types Of Transpose”

They say necessity is the mother of invention. But so, I’d say, are impatience and frustration. I find the sorting dialog in Excel on Mac a source of both of these. So I wrote some AppleScript to remove some of the friction. I’m sharing this because, yet again, I found nothing on the Web toContinue reading “Excel – Sorted With AppleScript”

In Automating Microsoft Excel I wrote about some basic manipulation of graphs in Excel for Mac OS, using AppleScript. I’m writing about it again because of the paucity of examples on the web. Here is an example that shows how to do a number of things in that vein. tell application "Microsoft Excel" set cContinue reading “More AppleScript And Excel”