Showing tag results for Office

Hey, Scripting Guy! How can I open a Word document, read the first three characters, and then rename the file using those three characters?-- DG Hey, DG. To tell you the truth, we always get a chuckle any time we get a question that asks for our help in renaming files or folders. Why? Well, the Scripting Guy who writes this column has essentiall...

Hey, Scripting Guy! How can I search a Word document for any of 305 different words and highlight these words if they are found?-- SB Hey, SB. This might be hard for you to believe, but the rest of the technical writing community doesn’t exactly hold the Scripting Guys in awe. However, most of our fellow writers do grudgingly concede that w...

Hey, Scripting Guy! How can I save an Excel spreadsheet, and then save a copy of that spreadsheet as HTML?-- TH Hey, TH. You know, it’s interesting that you used the word “save” in your question. After all, the Scripting Guy who writes this column (who’s much lazier - um, much busier than usual) just glanced at the clock and realized, “Uh-oh: I ...

Hey, Scripting Guy! How can I right-align a single column in a Word table?-- RC Hey, RC. You know, one of the phrases no one ever wants to hear is “This isn’t as bad as it looks.” After all, that’s what your business partner says when you discover he’s been using the company payroll to buy lottery tickets. “This isn’t as bad as it looks,” is the...

Hey, Scripting Guy! How can I format an Excel spreadsheet so that it retains leading zeroes?-- AS Hey, AS. You know, one of the Scripting Guys still has nightmares about the number zero. Several years ago he got a phone call from a friend of his wondering if he’d be interested in helping coach a youth league basketball team (10- and 11-year-olds...