Scripting Blog [archived]

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

Excel spreadsheet - Scripting Blog [archived]

How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?

September 6, 2007 Sep 6, 2007 09/6/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I get a list of all the email addresses in my Sent Items and then write those addresses to an Excel spreadsheet?-- RD(image) (image) (image) Hey, RD. As a matter of fact, yes, we are having problems focusing on work today. Granted, that’s true most days. However, at least today it’s understandable, ...

How Can I Add a Background Picture to an Excel Worksheet?

September 5, 2007 Sep 5, 2007 09/5/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I add a background picture to an Excel worksheet?-- GA(image) (image) (image) Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats his daily doughnut. (But don’t worry: it’s a medically-...

How Can I Replace Numeric Values in an Excel Spreadsheet?

August 25, 2007 Aug 25, 2007 08/25/07
ScriptingGuy1
(image) Hey, Scripting Guy! We have a spreadsheet where people enter a bunch of data. In order for this data to be used in another application, none of the values can exceed 999; if we have a value like 1234, that’s supposed to be entered as 999, the maximum-allowed value. However, people have a tendency to enter the value as 1234; that ...

How Can I Copy Data From One Spreadsheet to Another?

August 22, 2007 Aug 22, 2007 08/22/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I copy data from one Excel spreadsheet to another Excel spreadsheet?-- AC (image) (image) (image) Hey, AC. You know, we’re going to let you in on a little secret here: the Scripting Guy who writes this column is a tad bit tired this morning. That’s because he arrived home late last night (well after ...

How Can I Replace Text in an Excel Spreadsheet?

August 16, 2007 Aug 16, 2007 08/16/07
ScriptingGuy1
(image) Hey, Scripting Guy! How can I replace text in an Excel spreadsheet?-- PD (image) (image) (image) Hey, PD. We’ll talk about replacing text in an Excel spreadsheet in just a moment. But first, let’s address the question that’s on everyone’s mind: what is the Scripting Guy who writes this column going to do today as his ...