A place to learn about PowerShell and share stories of automation
March 31, 2005Mar 31, 200503/31/05Hey, Scripting Guy! How can I determine the size of the My Documents folder?— SC
Hey, SC. The My Document folder is actually just another folder on the hard disk, one with a path similar to this: C:\Documents and Settings\kenmyer\My Documents.
March 30, 2005Mar 30, 200503/30/05Hey, Scripting Guy! I’d like to copy one of the worksheets in an Excel workbook and then paste that copy into the very same workbook; once it’s pasted it, I’d like to rename it. Can I do that?— JG
Hey, JG.
March 29, 2005Mar 29, 200503/29/05Hey, Scripting Guy! How can I clear a list box in an HTA?— AK
Hey, AK. For those of you who aren’t familiar with the term, an HTA – among other things – is a way to use Internet Explorer to provide a graphical user interface for your scripts.
March 28, 2005Mar 28, 200503/28/05Hey, Scripting Guy! How can I check a text file to see if a word appears in that file and, if it doesn’t, add the word to the file?— JO
Hey, JO. We seem to have gotten quite a few questions on this topic lately.
March 25, 2005Mar 25, 200503/25/05Hey, Scripting Guy! I’m using the FileSystemObject to create an XML file. However, I need to put double quote marks around some of the items in that file. How do I do that?— JP
Hey, JP. According to your email, you’re trying to write the following line to your XML file:<?
March 23, 2005Mar 23, 200503/23/05Hey, Scripting Guy! How can I set an Active Directory property to NULL? I tried setting the value to an empty string (“”) but it didn’t work.— JJ
Hey, JJ. You know, it’s not like the Scripting Guys to get philosophical;
March 22, 2005Mar 22, 200503/22/05Hey, Scripting Guy! I’d like to be able to open an Excel spreadsheet, get all the information off one of the worksheets, and then save that worksheet data to a comma-separated values file. How can I do that?
— SS
Hey,
March 21, 2005Mar 21, 200503/21/05Hey, Scripting Guy! Is there a way I can be notified any time a network cable gets unplugged on a computer?— DD
Hey, DD. A lot of people, when growing up, had a grandmother or an aunt or someone somewhere who had a house with a big attic,
March 18, 2005Mar 18, 200503/18/05Hey, Scripting Guy! Can I create an environment variable using a script?— OD
Hey, OD. WMI is a great technology for scripting, but it has its eccentricities. For example, can you create a process using a script? Of course you can;
March 17, 2005Mar 17, 200503/17/05Hey, Scripting Guy! I have a folder with a bunch of files in it. I need to move all those files; the only problem is that the files need to be moved to different folders depending on their file extensions. For example,
