Showing results for February 2005 - Page 4 of 4 - Scripting Blog [archived]

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, MC. W...

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 core scripting tec...

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 iterate throug...

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-scripting-Act...

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 CurrentDirectory p...