Showing tag results for Office

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 means that we can...

Hey, Scripting Guy! How can I copy data from one Excel spreadsheet to another Excel spreadsheet?-- AC 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 midnight) following a flight from Rome to...

Hey, Scripting Guy! How can I replace text in an Excel spreadsheet?-- PD 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 Italian vacation continues? Well, to be honest, the...

Hey, Scripting Guy! How can I insert a manual line break into a Microsoft Word document?-- YR 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 Scripting Guy) Peter Costantini. Peter, o...

Hey, Scripting Guy! How can I save all the items in my Sent Items folder that are more than one month old?-- RS 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 and valued employee of the Microsoft Corpor...