Scripting Blog [archived]

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

Office - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Retrieve the Field Size and a Sample Record For All the Tables and Fields in an Office Access Database?

October 3, 2007 Oct 3, 2007 10/3/07
ScriptingGuy1
(image) I recently read an article of yours that showed me how I can retrieve the names of all the tables in an Access database, along with a list of all the fields in each table and the data type of each of those fields. That’s a really useful script, but it would be even more useful if it could list the field size and also display a ...

How Can I Change the Paragraph Case in Microsoft Word?

September 25, 2007 Sep 25, 2007 09/25/07
ScriptingGuy1
(image) Hey, Scripting Guy! We have a bunch of Word documents that, for some reason, have been formatted using nothing but lowercase letters. We know exactly how we want to reformat these documents: all the headings (which are in 14-point type) should be in title case and all the other paragraphs should be in sentence case. Of course, it’s...

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

September 22, 2007 Sep 22, 2007 09/22/07
ScriptingGuy1
(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 ...