Scripting Blog [archived]

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

How Can I Replace Numeric Values in an Excel Spreadsheet?

(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?

(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?

(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 ...

How Can I Insert a Manual Line Break into a Microsoft Word Document?

(image) Hey, Scripting Guy! How can I insert a manual line break into a Microsoft Word document?-- YR (image) (image) (image) Hey, YR. Greetings (saluti) from Rome, the Eternal City! You know, according to legend, Rome was founded thousands of years ago by the twins Romulus and Remus, along with their distant cousin (and oldest living ...

How Can I Save Emails That Are More Than One Month Old?

(image) Hey, Scripting Guy! How can I save all the items in my Sent Items folder that are more than one month old?-- RS(image) (image) (image) Hey, RS. You know, we’d like to answer this question; we really would. However, the Scripting Guy who writes this column is leaving on vacation tomorrow, which means that – being an important ...