How Can I Sort Worksheets in a Workbook?

Hey, Scripting Guy! How can I sort worksheets in a workbook?– FS Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process…

8

How Can I Add Multiple Tables to a Word Document?

Hey, Scripting Guy! How can I add multiple tables to a Word document?– KH Hey, KH. You know, if the Scripting Guys have one failing (hey, we said if) it’s this: we’re simple guys with simple tastes. Create a Microsoft Word document with multiple tables? No, sir; that’s not for us, not at all. One…

8

How Can I Use Windows PowerShell to Start a Service on a Remote Computer?

Hey, Scripting Guy! How can I use Windows PowerShell to start a service on a remote computer? — NA Hey, NA. You know, a few years ago a professor named Francis Fukuyama wrote a book called The End of History and the Last of Man, a book which stated (well, sort of) that now that…

8

How Can I List All the Printers on a Remote Computer?

Hey, Scripting Guy! How can I list all the printers – both local printers and network printers – on a remote computer?– CH Hey, CH. You know, back when he worked at the University of Washington the Scripting Guy who writes this column was asked to speak at a symposium being held as part of…

8

How Can I Delete Just the Last Line of a Text File?

Hey, Scripting Guy! How can I delete just the last line of a text file?– AD Hey, AD. You know, it’s been a long, hard day here at Microsoft, one of those days when everyone and everything seems to be against you. Many people, when faced with a day like today, turn to the so-called…

8

How Can I Compact an Access Database?

Hey, Scripting Guy! How can I compact an Access database using a script?– DA Hey, DA. We have to tell you the truth: we are thrilled and excited about getting the chance to answer your scripting question. To be honest, that isn’t always the case, most days we’d look at a question like this and…

8

How Can I Determine the OU the Local Computer Belongs To?

Hey, Scripting Guy! In a logon script, which attribute do I use to determine the OU that the local computer belongs to?– JP Hey, JP. Most people are familiar with Cupid, the Roman god of love. In fact, you’d be hard-pressed to find anyone who doesn’t know that Cupid carries with him a quiver of…

8

How Can I Search a Text File for Strings Meeting a Specified Pattern?

Hey, Scripting Guy! How can I search a text file of product IDs and retrieve just those lines that meet a specified pattern?– WT Hey, WT. Before we get to today’s question we were wondering if anyone else has seen the commercial for the car that features the all-new “heartbeat sensor?” The idea is that,…

8