Scripting Blog

A place to learn about PowerShell and share stories of automation

July 2006 - Page 2 of 4 - Scripting Blog

How Can I Replace Selected Lines in an XML File?

July 24, 2006 Jul 24, 2006 07/24/06
ScriptingGuy1
Hey, Scripting Guy! How can I read lines 56 to 62 in one XML file, and replace those with lines 56 to 62 taken from another XML file?-- JA Hey, JA. First of all, we’d like to thank you for your question; in addition, we’d like to welcome you and everyone else to today’s Open House in honor of the 501st Hey, Scripting Guy! column. We ...

How Can I Subtract a Specified Number of Days from a UTC Value?

July 21, 2006 Jul 21, 2006 07/21/06
ScriptingGuy1
Hey, Scripting Guy! Suppose I get a date-time value in UTC format. How can I subtract x number of days from that value?-- MW Hey, MW. First of all, we’d like to thank you for your question; in addition, we’d like to welcome you and everyone else to today’s Open House in honor of the 500th Hey, Scripting Guy! column. We know that a few...

How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?

July 20, 2006 Jul 20, 2006 07/20/06
ScriptingGuy1
Hey, Scripting Guy! How can I tell if a specified worksheet exists in an Excel workbook?-- MVK Hey, MVK. Back when he was in high school (that was about 3 or 4 years ago, of course), the Scripting Guy who writes this column was kind of half-watching a variety show on TV. The show featured a man and his dogs: “The Smartest Dogs in the ...

How Can I Set the Default Printer Based on the IP Address of the Computer?

July 19, 2006 Jul 19, 2006 07/19/06
ScriptingGuy1
Hey, Scripting Guy! How can I set the default printer based on the IP address of the computer?-- TT Hey, TT. You’ll have to forgive us for being a little distracted this morning. Last night the Scripting Guy who writes this column went to the gym with his 16-year-old son. For the first time ever, the Scripting Son was able to bench press ...

How Can I Create a Logon Script That Will Open a User’s Mapped Drives?

July 18, 2006 Jul 18, 2006 07/18/06
ScriptingGuy1
Hey, Scripting Guy! How can I create a logon script that will open a user’s mapped drives?-- KZ Hey, KZ. You know, a lot of people think we decided to write this column because we wanted yet another way to tell people about scripting. That’s partially true; however, another reason there’s a Hey, Scripting Guy! column is because the ...