Scripting Blog

A place to learn about PowerShell and share stories of automation

Microsoft Excel - 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 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 Modify a .CSV File and Then Import That File into Microsoft Excel?

May 7, 2008 May 7, 2008 05/7/08
ScriptingGuy1
Hey, Scripting Guy! I have a comma-separated values file that I need to import into Excel. However, before I do that I need to do some arithmetic and then add an additional field to the CSV file. On top of that, when I import this file I need to format this new field as a date-time value. How can I do that?-- R Hey, R. Well, by now most of ...

Hey, Scripting Guy! How Can I Change the Value and Color of a Spreadsheet Cell Based on the Sum of Other Cells in That Spreadsheet?

May 1, 2008 May 1, 2008 05/1/08
ScriptingGuy1
Hey, Scripting Guy! I’m new to Excel, and I was wondering how to change the color of a cell if specific requirements are met. I have a spreadsheet that has three columns of numbers; I’d like to add the numbers in each row and, if they total 100, set the text of a fourth column to “Yes” and color that cell green. If the numbers don...

Hey, Scripting Guy! How Can I Import a Fixed-Width Data File into Microsoft Excel?

April 15, 2008 Apr 15, 2008 04/15/08
ScriptingGuy1
Hey, Scripting Guy! How can I import a fixed-width data file into Microsoft Excel?-- RS Hey, RS. This column is being written on a Friday morning, and so far it’s been a very weird morning at that. For one thing, it’s not raining and – if you look closely – you can even see the sun. (It’s been awhile, but we’d recognize the sun ...