Scripting Blog

A place to learn about PowerShell and share stories of automation

September 2007 - Page 3 of 4 - Scripting Blog

How Can I Extract Text Embedded Between Target Phrases in a Text File?

September 15, 2007 Sep 15, 2007 09/15/07
ScriptingGuy1
Hey, Scripting Guy! How can I read a text file until I encounter a specified phrase, then write that information to a new text file? I then need to repeat this process, reading the text file to the next instance of the phrase and then writing that information to another new file. And so on.-- EW Hey, EW. You know, this has been a difficult ...

How Can I Determine Which Version of Windows Vista is Installed on a Computer?

September 14, 2007 Sep 14, 2007 09/14/07
ScriptingGuy1
Hey, Scripting Guy! How can I determine which version of Windows Vista is installed on a computer?-- GC Hey, GC. You know, Microsoft is one of the largest and most successful companies the world has ever known. And yet, despite all our successes, we’re really no different than any anyone else: for example, from time-to-time we get a ...

How Can I Update and Then Break All the Links in an Excel Spreadsheet?

September 13, 2007 Sep 13, 2007 09/13/07
ScriptingGuy1
Hey, Scripting Guy! How can I open an Excel spreadsheet, update all the links to other Excel spreadsheets, and then break those links?-- YH Hey, YH. Before we begin, we’d like to make an announcement: the Scripting Guy who writes this column gives up. To tell you the truth, that’s not something we ever expected to say; after all, the ...

How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?

September 12, 2007 Sep 12, 2007 09/12/07
ScriptingGuy1
Hey, Scripting Guy! How can I loop through a folder, open all the Excel files in that folder, then run a specified macro in each of those Excel files?-- BR Hey, BR. So, did you watch college football this past Saturday? In particular, did you watch as the Washington Huskies dismantled Boise State 24-10, snapping the Bronco’s nation’s-...

How Can I Assign Multiple Home Pages to Internet Explorer 7.0?

September 11, 2007 Sep 11, 2007 09/11/07
ScriptingGuy1
Hey, Scripting Guy! How can I configure Internet Explorer 7 so it uses multiple home pages?-- PI Hey, PI. Just a second; before we begin, is anyone from Microsoft reading today’s column? Don’t be shy; raise your hand if you’re from Microsoft. No one, not a single Microsoft employee is reading today’s column? Excellent. What ...