# 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: How Can I Replace Numeric Values in an Excel Spreadsheet?

Hey, Scripting Guy! We have a spreadsheet where people enter a bunch of data. In order for this data to be used in another application, none of the values can exceed 999; if we have a value like 1234, that’s supposed to be entered as 999, the maximum-allowed value. However, people have a tendency to...
• #### Blog Post: How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?

Hey, Scripting Guy! How can I change all the lowercase letters in an Excel worksheet to uppercase letters? -- BC Hey, BC. Have you ever heard the old expression, “If you want something done you have to do it yourself”? Well, to tell you the truth, we Scripting Guys had heard of that old expression...
• #### Blog Post: How Can I Set the Print Area in an Excel Spreadsheet?

Hey, Scripting Guy! How can I set the print area in an Excel spreadsheet? -- PRP Hey, PRP. You know, before the Scripting Guy who writes this column wrote his very first column he took a sacred vow: he vowed never to take a sacred vow, at least not when it came to writing the Hey, Scripting Guy! column...
• #### 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 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: Hey, Scripting Guy! How Can I Import Data into Office Access from Office Excel?

Hey, Scripting Guy! I need to do hardware inventory on all our workstations and on all our servers. I know System Center Configuration Manager can do this and a whole lot more. We actually have it budgeted for deployment next year. However, that does not help me now. We had a summer intern that went...
• #### Blog Post: How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?

Hey, Scripting Guy! In an Excel spreadsheet, how can I locate and replace information for a specific computer? -- BB Hey, BB. You know, there’s an old saying that goes, “If all you have is a hammer then everything looks like a nail.” Well, all we Scripting Guys have at the moment is some code for...
• #### Blog Post: How Can I Sort a Row in an Excel Spreadsheet?

Hey, Scripting Guy! How can I sort a row in an Excel spreadsheet? -- RF Hey, RF. You know, this is a tough question, but as a resident of the state of Washington the Scripting Guy who writes this column doesn’t shy away from a challenge. Therefore, he fully intends to address this matter … in the...
• #### Blog Post: How Can I Sort Worksheets in a Workbook?

Hey, Scripting Guy! How can I sort worksheets in a workbook? -- FS Hey, FS. How can you sort worksheets in a workbook? Well, to tell you the truth, not as easily as we had hoped you could sort worksheets in a workbook. This doesn’t mean it can’t be done; it just means that the process is a tiny bit...
• #### Blog Post: Hey, Scripting Guy! How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?

Hey, Scripting Guy! I need a script that can read all the values in a spreadsheet and then change the background colors of the cells in that spreadsheet based on a range of values. For example, if the value is less than 20 the cell gets colored one color; if the cell is between 20 and 40 it gets colored...
• #### Blog Post: How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?

Hey, Scripting Guy! How can I get a list of all the email addresses in my Sent Items and then write those addresses to an Excel spreadsheet? -- RD Hey, RD. As a matter of fact, yes, we are having problems focusing on work today. Granted, that’s true most days. However, at least today it’s understandable...
• #### Blog Post: Hey, Scripting Guy! How Can I Insert New Rows Above the Last Row in an Office Excel Spreadsheet?

Hey, Scripting Guy! I have an Office Excel spreadsheet in which the last row in the spreadsheet sums all the rows above it. How can I add new rows (and new data) to this spreadsheet, making sure that the last row always sums up all the rows above it? -- AW Hey, AW. By the way, please excuse the mess;...
• #### Blog Post: How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?

Hey, Scripting Guy! How can I take user names from an Excel spreadsheet, search for those users in Active Directory, and then indicate whether or not each user was found? -- SD Hey, SD. You know, one of the drawbacks to writing a daily scripting column is that people never seem to believe you. For...
• #### Blog Post: How Can I Save a Table in an Access Database as a Spreadsheet?

Hey, Scripting Guy! How can I save a table in an Access database as an Excel spreadsheet? -- OT Hey, OT. You know, we appreciate the question, but where were you last week, when we really needed you? The truth is, last week was excruciatingly dull, at least for two of the Scripting Guys. While Scripting...
• #### Blog Post: How Can I Import an Excel Spreadsheet Into an Access Database?

Hey, Scripting Guy! How can I import an Excel spreadsheet into an Access database? -- IE Hey, IE. Wait! Don’t tell us; let us guess. Just a moment … we’re picking up the vibrations now … the sensation is getting stronger and more distinct … OK, got it: you’d like to know how to import an Excel spreadsheet...
• #### Blog Post: Hey, Scripting Guy! How Can I Mark the First Occurrence of a Number in an Office Excel Spreadsheet?

Hey, Scripting Guy! I’m trying to determine – and mark – the first occurrence of a number in an Office Excel worksheet. However, I can’t figure out how to go about doing this. Can you help? -- BH Hey, BH. Before we launch into today’s column we have an announcement...

Hey, Scripting Guy! In a previous column, you told us a couple different ways to save Excel spreadsheets. In that column, you said that one of the things you could do with the SaveAs method was password-protect a spreadsheet. However, you didn’t show us an example of this. How can I use a script to password...
• #### Blog Post: How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?

Hey, Scripting Guy! How can I assign a background color (based on a specified value) to a spreadsheet cell and then “sum” those cells? -- JC Hey, JC. Thanks for the question. And yes, you heard correctly: in his last game the Scripting Son did indeed go 4-for-4, banging out three singles and a double...
• #### Blog Post: Hey, Scripting Guy! How Can I Copy the Extended Data of My Audio Files to an Excel Spreadsheet?

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