Hey, Scripting Guy! How can I open an existing Excel spreadsheet, add some additional information to that spreadsheet, and then save my changes? Every time I call the SaveAs method a dialog box pops up asking me if I want to save my changes.—
Hey, Scripting Guy! Is there any way I can use a script to present a user with a dialog box and let him or her select a file?— BF
Hey, BF. If you’re using Windows 2000, we don’t know of a way to do this,
Hey, Scripting Guy! Is there any way to retrieve the system time as configured on a remote computer?— JJ
Hey, JJ. There are at least two ways to do this, both using WMI. If you’re running Windows XP or Windows Server 2003,
Hey, Scripting Guy! How can I scan the event logs of my servers and return only information about unsuccessful logons?— LC
Hey, LC. We’ll assume that you have enabled security auditing on your servers. If you haven’t, that’s step one. What you’ll want to do is –
Hey, Scripting Guy! How can I read only a specific line in a text file? For example, how can I write a script that reads only line 16 in a text file and then stores the value of that line in a variable?—
Hey, Scripting Guy! How can I determine the next available drive letter on a computer?— TW
Hey, TW. Interesting question, and one that crops up from time-to-time. In the old days, when users only had drives A, B, and C, this was easy;
Hey, Scripting Guy! I need to move a computer account from one OU to another; however, I don’t know which OU the computer account is currently in. Any advice?— AA
Hey, AA. You know, one thing that marks all the great advice columns –
Hey, Scripting Guy! Is there any way to tell which command-line arguments (if any) were used when starting an executable file?— TO
Hey, TO. We don’t mean to cause a scandal in the scripting world – well, OK, we don’t mean to cause any more scandals in the scripting world.
Hey, Scripting Guy! Instead of having the My Computer icon on the desktop read My Computer, I’d like to replace that with the name of the computer. Can I do that using a script?— TG
Hey, TG. We get asked this question quite a bit;
Hey, Scripting Guy! Is it possible to use a script to change the read-only attribute of a file?— ZO
Hey, ZO. Of course, you can do this; the FileSystemObject can do anything!
Well, OK, it can’t do either of those things.