Scripting Blog

A place to learn about PowerShell and share stories of automation

Excel.Application - Scripting Blog

Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?

November 2, 2007 Nov 2, 2007 11/2/07
ScriptingGuy1
Hey, Scripting Guy! How can I determine the value of the last cell in a range like C1:C10?-- MJdR Hey, MJdR. You know, just a few days ago word leaked that a Federal Emergency Management Agency (FEMA) press conference held to discuss the US government’s response to the recent spate of wildfires in California was a fake. Instead of having ...

Hey, Scripting Guy! How Can I Convert a Number to a Date and Then Back in Excel?

October 22, 2007 Oct 22, 2007 10/22/07
ScriptingGuy1
Hey, Scripting Guy! We have a spreadsheet that includes numbers like this: 31738. However, this isn’t supposed to be a number, it’s actually supposed to be a date: 11/22/1986. How can I convert these numbers to dates and then, if needed, convert those dates back to numbers?-- TC Hey, TC. Yes, as a matter of fact it did take 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 Add a Background Picture to an Excel Worksheet?

September 5, 2007 Sep 5, 2007 09/5/07
ScriptingGuy1
Hey, Scripting Guy! How can I add a background picture to an Excel worksheet?-- GA Hey, GA. You know, being the health-conscious type, each morning the Scripting Guy who writes this column eats some non-fat raspberry yogurt … right before he eats his daily doughnut. (But don’t worry: it’s a medically-proven fact that eating yogurt ...

How Can I Copy Selected Columns From a CSV File to an Excel File?

June 4, 2007 Jun 4, 2007 06/4/07
ScriptingGuy1
Hey, Scripting Guy! How can I copy selected columns from a CSV file to an Excel file?-- MdP Hey, MdP. One thing that people always worry about (and rightly so) is that one of these days the Scripting Guys will do something that tears a hole in the space-time continuum. Some of you might be concerned that this has finally happened: after ...