Hey, Scripting Guy! In a previous column, you told us a couple different ways to save Excel spreadsheets. In that column, you said that one of the things you could do with the SaveAs method was password-protect a spreadsheet. However, you didn’t show us an example of this. How can I use a script to password-protect a spreadsheet?-- MC
Hey...
Hey, Scripting Guy! How can I mask passwords using an InputBox?-- PG
Hey, PG. If you’re hoping to mask passwords using a function or method built into WSH or VBScript we’re afraid you’ll be disappointed; neither technology supports password masking. That doesn’t mean you can’t do it, it just means we’ll have to look beyond the ...
Hey, Scripting Guy! How can I check a computer and find out whether the Remote Desktop Users group has any members?-- ET
Hey, ET. Somewhat surprisingly, ADSI doesn’t have any sort of NumberOfMembers property, a property that could tell you - at a glance - how many members are in a group. But that’s all right, because we can simply ...
Hey, Scripting Guy! How can I gather the names of all the computers in my domain that are running Windows Server 2003?-- AS
Hey, AS. When we choose questions to answer for this column, we try to take questions from different areas of scripting. That does two things for us: it keeps us from being the answers-only-questions-about-say-...
Hey, Scripting Guy! My script needs to have the same working folder as the application that the script starts. How can I change the working folder of a script?-- JM
Hey, JM. You can change the current (or working) folder of a script simply by setting the value of the Wscript Shell object’s CurrentDirectory property. (Note. The ...