Scripting Blog [archived]

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

Office - Scripting Blog [archived]

Hey, Scripting Guy! How Can I Delete a Set of Records From an Access Database?

January 3, 2008 Jan 3, 2008 01/3/08
ScriptingGuy1
(image) Hey, Scripting Guy! We have an Access database that we use to keep track of resources that are associated with all of our projects. Periodically I need to go into the database and delete all the records tied to a particular project. Is there any way that I can do that using a script?-- WK(image) (image) (image) Hey, WK. Having been...

Hey, Scripting Guy! How Can I Run a Script Any Time Office Outlook is Started?

November 15, 2007 Nov 15, 2007 11/15/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I run a script any time Outlook is started?-- AT(image) (image) (image) Hey, AT. Today is Wednesday, and Wednesday is a busy day here at TechEd IT Forum. For one thing, this afternoon the Scripting Guys will be making a guest appearance at the TechNet Magazine booth. What will they be doing there? Well, ...

Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?

November 2, 2007 Nov 2, 2007 11/2/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I determine the value of the last cell in a range like C1:C10?-- MJdR(image) (image) (image) Hey, MJdR. You know, just a few days ago word leaked that a Federal Emergency Management Agency (FEMA) press conference held to discuss the US government’s response to the recent spate of wildfires in ...

Hey, Scripting Guy! How Can I Determine the Age, in Years, of an Office Outlook Contact?

October 31, 2007 Oct 31, 2007 10/31/07
ScriptingGuy1
(image) Hey, Scripting Guy! Given the birthday for one of my Office Outlook contacts, how can I tell how old that person is?-- JC(image) (image) (image) Hey, JC. We have to tell you, JC, that you initially gave us quite a start with this question. Why? Well, when the Scripting Guy who writes this column sat down to write this column, he ...

Hey, Scripting Guy! How Can I Be Notified if an Access Database File Exceeds a Specific Size?

October 25, 2007 Oct 25, 2007 10/25/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I trigger an alert if an Access database file exceeds a specific size?-- MA(image) (image) (image) Hey, MA. You know just the other day Microsoft.com posted 100 Reasons You'll Be Speechless, a Web page listing 100 reasons why “Seeing Windows Vista for the first time may leave you searching for words...