How Can I Add a Hyperlink to an Excel Spreadsheet?

Hey, Scripting Guy! How can I add a hyperlink to an Excel spreadsheet?– J B-N Hey, J B-N. To begin with, we’d like to point out that we’re well aware of all the recent media scandals involving such prestigious organizations as The New York Times. As you know, many of those scandals revolve around writers…

2

How Can I Determine the ADsPath for the Logged-On User?

Hey, Scripting Guy! In my HTA, how can I determine the ADsPath for the logged-on user?– AC Hey, AC. You know, when you work at Microsoft people automatically assume that you spend your days in an ivory tower, totally removed from the day-to-day activities and needs of system administrators. To be honest, that isn’t true:…

0

How Can I Determine the Name of the Local Administrators Group?

Hey, Scripting Guy! How can I determine the name of the local Administrators group? This can vary depending on the operating system language; for example, in German the name of the group is Administratoren.– DS Hey, DS. You know, the first thought that popped into our heads when we read your question was this: just…

0

How Can I Change a User’s sAMAccountName?

Hey, Scripting Guy! How can I change the sAMAccountName from KMyer to Ken.Myer?– CP Hey, CP. You know, William Shakespeare once said, “A rose by any other name would smell as sweet.” What does that have to do with your question abut changing the sAMAccountName for a user? Nothing really; it’s just that every now…

6

How Can I Start an Application From an HTA?

Hey, Scripting Guy! Is there an alternative to the Wscript.Shell command for HTAs? I need to run an application and specify the file to open.– DL Hey, DL. Yes, we do know of an alternative to the Wscript.Shell command that will work in HTAs, and we’ll show you that in a minute. Before we do…

16

How Can I Determine Which Drives are Mapped to Network Shares?

Hey, Scripting Guy! How can I determine which drives on a computer are mapped to network shares?– CP Hey, CP. OK, you better sit down, because what we’re about to say will shock you: if you want to determine which drives on a computer are mapped to network shares, don’t use the Win32_MappedLogicalDisk class. Oh,…

15

How Can I Determine if an OU is Blocking Group Policy Inheritance?

Hey, Scripting Guy! How can I determine if an OU has the Group Policy property Block Policy Inheritance box checked?– PP Hey, PP. You know, sometimes you wait all your life for a situation to arise, and then it never arises. For example, one of the Scripting Guys happens to know all nine verses to…

2