# Browse by Tags

Tagged Content List
• #### Blog Post: How Can I Change the Footer in an Excel Spreadsheet?

Hey, Scripting Guy! How can I change the footer in an Excel spreadsheet? -- JA Hey, JA. Ah, a trick question, huh? As it turns out, there’s no such thing as the footer in Excel; instead, Excel has three different footers: the left footer, the center footer, and the right footer. And here’s a script...
• #### Blog Post: Hey, Scripting Guy! How Can I Cut a Row From One Office Excel Spreadsheet and Paste That Row Into Another Spreadsheet?

Hey, Scripting Guy! How can I cut a row from an Office Excel spreadsheet and paste it into the first unused row in another Excel spreadsheet? -- NC Hey, NC. We apologize if today’s column feels a little damp; as it turns out, those of us in the Seattle area are experiencing another one of the Puget...
• #### Blog Post: Hey, Scripting Guy! How Can I Save an Office Excel Chart as a Picture?

Hey, Scripting Guy! How can I save an Office Excel chart as a picture? -- JB Hey, JB. You know, yesterday was a good day for the Scripting Guy who writes this column. If the phone rings at the Scripting House and if it’s for the Scripting Guy who writes this column, well, it’s never...
• #### Blog Post: 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?

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...
• #### Blog Post: Hey, Scripting Guy! How Can I Convert an Office Excel Spreadsheet to XML?

Hey, Scripting Guy! How can I convert an Office Excel spreadsheet to XML? -- KE Hey, KE. We apologize in advance if today’s column seems a little rushed; at the moment, we’re sitting in an office, surrounded by boxes and packing crates and waiting for the movers to come in and clear...
• #### Blog Post: How Can I Get a List of Available Metadata for Microsoft Office Documents?

Hey, Scripting Guy! How can I get a list of available metadata for Microsoft Office documents? -- JR Hey, JR. If we understand your question correctly, you’d like to know if it’s true that July 21, 2006 will mark the 500 th Hey, Scripting Guy! column; in addition, you’d like to...
• #### Blog Post: How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?

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...
• #### Blog Post: How Can I Copy Selected Columns From a CSV File to an Excel File?

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...
• #### Blog Post: Hey, Scripting Guy! How Can I Determine the Value of the Last Cell in an Office Excel Range?

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...
• #### Blog Post: How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?

Hey, Scripting Guy! How can I rename a bunch of folders using a script? The old folder names are in the first column of an Excel spreadsheet and the new folder names are in the second column of an Excel spreadsheet. -- SF Hey, SF. Oh, and welcome to Hey, Scripting Guy! , your daily source for scripting...
• #### Blog Post: Hey, Scripting Guy! How Can I Change the Font Color in Office Excel If a Specified Condition is Met?

Hey, Scripting Guy! In an Office Excel spreadsheet, how can I change the color of the text if the value in column B minus the value in column A is greater than or equal to 10? -- EP Hey, EP. You know, before the Scripting Guy who writes this column started writing this column, he vowed that Hey...
• #### Blog Post: Hey, Scripting Guy! How Can I Import a Fixed-Width Data File into Microsoft Excel?

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...
• #### Blog Post: How Can I Use Windows PowerShell to Automate Microsoft Excel?

Hey, Scripting Guy! How can I use Windows PowerShell to automate Microsoft Excel? -- MW Hey, MW. Yes, it’s true: the week of November 6-10, 2006 will be Windows PowerShell Week on TechNet, with the Scripting Guys presenting a series of webcasts (one each day, Monday through Friday) designed to introduce...
• #### Blog Post: How Can I Add a Total Row to an Excel Spreadsheet?

Hey, Scripting Guy! How can I add a bunch of rows to an Excel spreadsheet and then stick a total row at the bottom? -- MW Hey, MW. Could we ask you a favor: is there any chance that you could write back later with this question? As you may or may not know, the University of Washington men’s basketball...
• #### Blog Post: Hey, Scripting Guy! How Can I Convert a Number to a Date and Then Back in Excel?

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...
• #### Blog Post: How Can I Insert a Column into a Spreadsheet?

Hey, Scripting Guy! How can I insert a column into an Excel spreadsheet? -- HE Hey, HE. Let’s assume you have a spreadsheet that looks something like this: And, yes, it is a very nice little spreadsheet, except for one problem. As you can see, we goofed, and we forgot to insert Dataset 3; instead...
• #### Blog Post: How Can I Create a New Excel Spreadsheet at Midnight Each Night?

Hey, Scripting Guy! How can I create a new Excel spreadsheet at midnight each night? I’d like each spreadsheet to have a file name similar to this: 6-1-06.xls . -- DH Hey, DH. You know, often-times the simplest approach is also the best approach. For example, the other night the Scripting Son was...
• #### Blog Post: How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?

Hey, Scripting Guy! How can I copy column C of one worksheet to column A of a second worksheet? -- JP Hey, JP. Well, that’s easy: you just open Excel, highlight column C, press Ctrl+C, put the cursor in column A1 of the second worksheet, and then press Ctrl+V. There you go, and thanks for your question...
• #### Blog Post: Hey, Scripting Guy! How Can I Set the Default File Path in Office Excel to a User’s Home Directory?

Hey, Scripting Guy! How can I set Office Excel’s default file path to a user’s home directory? -- LL Hey, LL. We hope that the script we’re about to show you will answer your question; if it doesn’t, you might have to wait awhile before we can get back to you on it. That’s...
• #### Blog Post: How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?

Hey, Scripting Guy! How can I delete all the worksheets in an Excel spreadsheet except for the first worksheet? -- NN Hey, NN. Please excuse any bloodstains that might appear on your screen; as it turns out, the Scripting Guy who writes this column was involved in an … incident … this past weekend...
• #### Blog Post: How Can I Create a Custom Date Format in Microsoft Excel?

Hey, Scripting Guy! In Microsoft Excel, how can I display a date like 01/20/2006 using this format: 20060120? -- CM Hey, CM. Who do we make the check out to again? And for how much? Oh, sorry. After attending a parent meeting for the Scripting Son’s new baseball team the Scripting Guy who writes...
• #### Blog Post: How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?

Hey, Scripting Guy! In Excel, how can I compare a list of names found in one column with a list of names found in another column? -- GS Hey, GS. You know, in general we Scripting Guys are charged with presenting people with facts; in turn, we’re really supposed keep our opinions to ourselves. However...
• #### Blog Post: Hey, Scripting Guy! How Can I Separate The Month From the Year in a Date String Like 122007?

Hey, Scripting Guy! I have a column of data in Microsoft Excel that is formatted as MYYYY (12008 = January 2008) and MMYYYY (122007 = December 2007). I need to split these values into month and year, but I can’t figure out how to do that. Any suggestions? -- DW Hey, DW. Well, it’s finally beginning...
• #### Blog Post: How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?

Hey, Scripting Guy! In an Excel spreadsheet, how can I change the color of a row if there is a date stored a particular cell in that row? -- GL Hey, GL. Some of you might have noticed that there was no Hey, Scripting Guy! column yesterday. Is that because the Scripting Guys are slacking off and shirking...
• #### Blog Post: How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?

Hey, Scripting Guy! How can I open an Excel workbook and retrieve the names of all the worksheets? -- JG Hey, JG. It’s the first day back after a three-day weekend, and this morning all the Scripting Guys stumbled into the office and just stared blankly into space. (All in all, pretty much business...