Showing archive results for August 2007

Hey, Scripting Guy! How can I copy the folder structure of a folder (that is, a folder and all its subfolders) without copying the files as well?-- AS Hey, AS. If you’re one of the many people who simply can’t get through the day without knowing what the Scripting Guy who writes this column is up to as he traipses through Italy, well, here’s th...

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 combine lines in a text file?-- JN Hey, JN. So you need to know how to combine lines in a text file, huh? Well, to tell you the truth, we’re kind of in a hurry today; the Scripting Guy who writes this column is getting ready to head out to St. Peter’s and the Sistine Chapel. But tell you what: we don’t have to leave...

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 determine if the number of files in a series of folders exceeds a specified value?-- DP Hey, DP. Buongiorno. Le come sta? Tutto bene? What does all that mean? Io non so; Io non parlo Italiano. In other words: I don’t know; I don’t speak Italian. No, really: “Io non so; Io non parlo Italiano” actually does mean “I d...