-
What’s the name of my shape?
I always had problems to identify the names of the individual shapes of a slide in PowerPoint and therefore mostly proceeded with a VBA script or worked with trial and error.Now I have discovered the Selection Pane in PowerPoint. This way you don’t get the number of a shape but at least the unique name…
-
Controlling MS Powerpoint via Powershell
The creation of PowerPoint files in particular can cost you a lot of nerves. Especially frequently recurring tasks like status or quarterly reports can be automated with Powershell. It is important to create a good PowerPoint master template, which can then be filled using Powershell. It makes sense to run through the document twice, inserting…
-
Controlling MS Word via Powershell
MS Word can be automated using Powershell. This has the advantage that „normally“ processable office documents can be generated completely automatically and one can, for example, generate Word documents automatically from a MySQL database without having to deal with VBScript. Create an Office template for an scientific paper. The following script will produce a structured…
-
Controlling MS Excel via Powershell
The use of Excel can be largely automated using Powershell. This is especially useful if you want to repeat office tasks frequently and don’t want to have to deal with the strange VBAScript syntax, if you want to document infrastructure data or if you want to process information from the non-Mircrosoft world in Microsoft Office.…