Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

Hey, Scripting Guy! How Can I Retrieve the User Name and User Initials From Microsoft PowerPoint?

(image) Hey, Scripting Guy! In PowerPoint user information is stored under the Tools menu. I would like to know if there is a way to extract this data by using a script.-- TV(image) (image) (image) Hey, TV. You know, you might find this hard to believe, but the Scripting Guy who writes this column hardly ever loses anything; in fact, he’...

Hey, Scripting Guy! How Can I Copy Data from Excel to PowerPoint?

(image) Hey, Scripting Guy! As part of a demonstration I do on a regular basis, I’d like to be able to open an Excel spreadsheet, copy all the information on Sheet 1, and then paste that data into a new PowerPoint slide. How can I do all that using a script?-- JG(image) (image) (image) Hey, JG. You know, the Hey, Scripting Guy! column is...

How Can I Apply a New Template to a PowerPoint Presentation?

(image) Hey, Scripting Guy! My company has just created a new PowerPoint template, and has decided that we need to use this template for all our presentations. How can I apply this new template to all the presentations in my C:\Presentations folder?-- OI(image) (image) (image) Hey, OI. You know, this morning the Scripting Guy who writes ...

How Can I Configure PowerPoint to Print Handouts Instead of Slides?

(image) Hey, Scripting Guy! How can I configure the print options in PowerPoint so that, by default, handouts are printed rather than slides?-- OG (image) (image) (image) Hey, OG. You know, whoever said “Lightning never strikes twice in the same place” didn’t reckon on the Scripting Guys, did they? After all, less than a year after ...