A place to learn about PowerShell and share stories of automation
May 31, 2005May 31, 200505/31/05Hey, Scripting Guy! How can I open an Excel workbook and retrieve the names of all the worksheets?— JG
Hey, JG. It’s the first day back after a three-day weekend, and this morning all the Scripting Guys stumbled into the office and just stared blankly into space.
May 27, 2005May 27, 200505/27/05Hey, Scripting Guy! How can I change the Copy music to this location folder in Windows Media Player?— BD
Hey, BD. You know, a lot of people think that the reason we Scripting Guys don’t do very much work is because we’re just plain lazy.
May 26, 2005May 26, 200505/26/05
Hey, Scripting Guy! I’m using the Win32_ComputerSystem class to get the name of the logged-on user. The name comes back formatted like this: Domain\Name. How can I extract just the user name?— KW
Hey, KW. As our much-beloved and highly-respected editor reminded us the other day,
May 25, 2005May 25, 200505/25/05Hey, Scripting Guy! How can I save (to a separate file) all the paragraphs in a Word document that are formatted using a particular style, like Heading 1?— RN
Hey, RN. You know, when we first read this question we thought,
May 24, 2005May 24, 200505/24/05Hey, Scripting Guy! How can I use ADO to open a text file that has spaces in the file name?— TL
Hey, TL. You might not even remember sending us this question; to say it’s been awhile would be an understatement.
May 23, 2005May 23, 200505/23/05Hey, Scripting Guy! How can I correlate logical drives and physical disks?— LB
Hey, LB. We’ll make a deal with you: we’ll show you a script that can tell you which logical drives are found on which physical disks, and you promise not to say,
May 20, 2005May 20, 200505/20/05Hey, Scripting Guy! How can I remove the last carriage return-linefeed in a text file?— LEK
Hey, LEK. From the rest of your email you note that you’re using the FileSystemObject to read a text file, then using the contents of that text file as a query in another application.
May 19, 2005May 19, 200505/19/05Hey, Scripting Guy! At work we need to use a proxy server to connect to the Internet; when I take my laptop home to work, however, I don’t need to use a proxy server. I know I can use the Internet Options in Control Panel to change between using a proxy server and not using a proxy server;
May 18, 2005May 18, 200505/18/05Hey, Scripting Guy! Our auditors have suggested that we randomly pick projects to examine and ensure that each project was completed and signed off per company policy. Because these projects are numbered sequentially I thought maybe we could write a script that would randomly select the project numbers for us to audit.
May 17, 2005May 17, 200505/17/05Hey, Scripting Guy! How can I access Active Directory on a specific domain controller?
— SD
Hey, SD. You know, one of the cool things about Active Directory is that you usually don’t need to access the directory service on a specific domain controller.
