Showing results for Excel.Application - Scripting Blog [archived]

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 real ...

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 Scripting Guy...

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-best ...

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 ...

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 all, ...