Showing results for December 2005 - Scripting Blog [archived]

Hey, Scripting Guy! How can I retrieve the path to the Program Files folder on a computer?-- CC Hey, CC. How can you retrieve the path to the Program Files folder on a computer? Well, to be honest, not as easily as we thought you could. If you’re trying to retrieve the Program Files path on the local computer, well, that’s easy; retrieving the P...

Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet?-- JA Hey, JA. Ah, a trick question, huh? As it turns out, there’s no such thing as the footer in Excel; instead, Excel has three different footers: the left footer, the center footer, and the right footer. And here’s a script that can change all three of them:Set objExcel =...

Hey, Scripting Guy! How can I get the “grandparent” of an object in Active Directory?-- JG Hey, JG. Wait a second: is this “grandparent” thing some sneaky reference to the fact that the Scripting Guys (well, except for Jean, of course) are all starting to show their age a bit? OK; we just wanted to make sure. (Editor’s Note: Yes, that originally...

Hey, Scripting Guy! How can I delete the C$ share from a computer?-- RB Hey, RB. One quick clarification here: we can tell you how to temporarily delete the C$ share from a computer. However, the share will automatically be recreated any time the Server service is stopped and then restarted, or any time the computer is rebooted. Why? That’s just...

Hey, Scripting Guy! How can I create an HTA that doesn’t have a Close button in the title bar?-- AK Hey, AK. You know, you’ve presented us with a great moral and ethical quandary. After all, suppose we answer this question: suddenly the world might be inundated with HTAs that couldn’t be closed. We have this vision of unclosable, unstoppable HTA...