How Can I Retrieve the Path to the Program Files Folder on a Computer?

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…

2

How Can I Change the Footer in an Excel Spreadsheet?

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…

1

How Can I Get the “Grandparent” of an Object in Active Directory?

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…

0

How Can I Delete the C$ Share from a Computer?

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…

1

How Can I Create an HTA that Doesn’t Have a Close Button in the Title Bar?

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…

3

How Can I Add Additional Worksheets to an Excel Workbook?

Hey, Scripting Guy! How can I add additional worksheets to an Excel workbook? By default you get 3 worksheets, but I have a scenario in which I need a workbook that has 12 worksheets.— AA Hey, AA. You know, a couple years ago one the Scripting Guys helped put together an Excel spreadsheet for one…

5

How Can I Configure the History Setting in Internet Explorer?

Hey, Scripting Guy! How can I configure the Days to keep pages in history setting in Internet Explorer?— AK Hey, AK. To tell you the truth, at first we were a little hesitant about answering this question. Why? Well, we’ve all seen enough TV to know that you aren’t supposed to mess around with history….

1

How Can I Disable a Computer Account?

Hey, Scripting Guy! How can I disable a computer account?— MD Hey, MD. You know, our first thought when we read your question was to ask our very own Peter Costantini, a scripting guru who’s done a lot of work with Active Directory. For better or worse, however, Peter’s originally from New Jersey and is…

2

How Can I Delete Everyone Except the Administrator and the Domain Admins Group from the Local Administrators Group?

Hey, Scripting Guy! How can I delete everyone except the Administrator and the Domain Admins group from the local Administrators group?— JS Hey, JS. You know, when you become a doctor you have to take the Hippocratic Oath, which famously begins, “First, do no harm.” When you become a Scripting Guy you have to take…

7

How Can I Use Alternate Credentials When Searching Active Directory?

Hey, Scripting Guy! How can I use alternate credentials when searching Active Directory? — PT Hey, PT. So what’s the big idea here? Devoted readers of this column (both of them) know that we usually love tackling questions where the answer involves searching Active Directory. Why? That’s easy: because we don’t really answer those questions….

3