Scripting Blog

A place to learn about PowerShell and share stories of automation

May 2008 - Scripting Blog

Hey, Scripting Guy! How Can I Copy the Extended Data of My Audio Files to an Excel Spreadsheet?

May 31, 2008 May 31, 2008 05/31/08
ScriptingGuy1
Hey, Scripting Guy! We have quite a large collection of speeches and audio training sessions that are sorted by … well, by nothing. However, all the ID3 tags [the file’s extended data] are up-to-date. Is there a way to extract the ID3 information from these files into an Excel spreadsheet?-- FB Hey, FB. You know, here at Scripting Guys ...

Hey, Scripting Guy! How Can I Search For a Specific Style in a Folder Full of Microsoft Word Documents?

May 30, 2008 May 30, 2008 05/30/08
ScriptingGuy1
Hey, Scripting Guy! I have a folder with scores of Word documents in it. What I need to do is open each document, copy anything that uses the Heading 1 style, and then write that information (the file name and anything that uses the Heading 1 style) to a single text file. Is there a way to do this using a script?-- DN Hey, DN. You know, ...

Hey, Scripting Guy! How Can I Report Back File Dates Using Labels Like Today, Yesterday, and Last Week?

May 28, 2008 May 28, 2008 05/28/08
ScriptingGuy1
Hey, Scripting Guy! In Microsoft Outlook if you sort and group your email by date, you don’t just get groupings that show the date; instead, you get groupings like Today, Yesterday, Last Week, etc. I’d like to do something similar; I’d like to look at the last-modified date for all the files in a folder, then report back that date as ...

Hey, Scripting Guy! How Can I Tile Workbook Windows in Microsoft Excel?

May 28, 2008 May 28, 2008 05/28/08
ScriptingGuy1
Hey, Scripting Guy! I have a Windows PowerShell script that starts Excel and loads three comma-separated values files into separate workbooks. What I was wondering is whether there’s a way to have PowerShell tile these workbooks, either vertically or horizontally. I poked through various properties and searched the Web for ideas, but I ...

Hey, Scripting Guy! How Can I Extract Miscellaneous Computer Names From a Text File?

May 24, 2008 May 24, 2008 05/24/08
ScriptingGuy1
Hey, Scripting Guy! I have a text file containing thousands of events. I need to read each line in that file and look for the name of the computer where an operation failed. The computer names can – and will – vary in length; however, the name will always begin in character position 37, and be followed by the word failed. Oh, and there...