If the purpose of Version 5 was to add the ability to use Python in the context of md2pptx the purpose of version 6 is to extend md2pptx’s automation capabilities still further. This time instead of Python it’s AppleScript. The context is different too: With Version 5 the Python support runs the user-supplied code asContinue reading “md2pptx 6 Is Another Big Step Forward”
Tag Archives: applescript
Setting Axis Font Sizes In Excel With AppleScript
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”
Excel – Two Types Of Transpose
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”
Excel – Sorted With AppleScript
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”
More AppleScript And Excel
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”
Automating Microsoft Excel Some More
As I said in Automating Microsoft Excel, I thought I might write some more about automating Excel. Recall I wrote about it because finding snippets of code to do what you want is difficult. So if I can add to that meagre stockpile on the web, I’m going to. That other post was about automatingContinue reading “Automating Microsoft Excel Some More”
Automating Microsoft Excel
(This post is about automating Excel on Mac OS. If you’re not a Mac user this probably won’t interest you.) My Process From the creation of a CSV file onwards, automation is key: Creating a CSV file is one of two things: A program on z/OS. A piece of javascript code I have that turnsContinue reading “Automating Microsoft Excel”