Hey, Scripting Guy! scripts for Microsoft Excel

So if you've never visited Microsoft's Script Center on TechNet, you should definitely go over there and kick the tires a bit. Often. There is a wealth of information and scripts there, created by scripters from both the community and Microsoft. After poking around a bit, I found some of the Scripting Guy's snappy answers to scripting questions for Excel:

How Can I Summarize Information Found in a Spreadsheet Row?
How Can I Prevent Excel From Turning My Imported Numbers Into Dates?
How Can I Copy the Extended Data of My Audio Files to an Excel Spreadsheet?
How Can I Tile Workbook Windows in Microsoft Excel?
How Can I Modify a .CSV File and Then Import That File into Microsoft Excel?
How Can I Change the Value and Color of a Spreadsheet Cell Based on the Sum of Other Cells in That Spreadsheet?
How Can I Import a Fixed-Width Data File into Microsoft Excel?
How Can I Sort a Spreadsheet By Cell Color?
How Can I Check the Value of a Specific Cell in a Bunch of Excel Spreadsheets?
How Can I Mark the First Occurrence of a Number in an Excel Spreadsheet?
How Can I Read Custom Summary Information Properties for an Excel File?
How Can I Change the Color of a Spreadsheet Cell Based on a Range of Values?
How Can I Import Multiple Worksheets into an Access Database?
How Can I Search For Values in an Excel Worksheet?
How Can I Cut a Row From One Excel Spreadsheet and Paste That Row Into Another Spreadsheet?
How Can I Determine the Value of the Last Cell in an Excel Range?
How Can I Convert an Excel Serial Number to a Date and Then Back?
How Can I Insert New Rows Above the Last Row in an Excel Spreadsheet?
How Can I Copy Data from Excel to PowerPoint?
How Can I Retrieve Hyperlink Information From an Excel Spreadsheet?
How Can I Insert Blank Rows (and Formulas) Into an Excel Worksheet?
How Can I Update and Then Break All the Links in an Excel Spreadsheet?
How Can I Open All the Excel Spreadsheets in a Folder and Run a Specified Macro Found in Each of Those Spreadsheets?
How Can I List the Addresses in My Sent Items Folder in an Excel Spreadsheet?
How Can I Add a Background Picture to an Excel Worksheet?
How Can I Replace Numeric Values in an Excel Spreadsheet?
How Can I Copy Data From One Spreadsheet to Another?
How Can I Replace Text in an Excel Spreadsheet?
How Can I Set the Print Area in an Excel Spreadsheet?
How Can I Delete Specified Rows in an Excel Spreadsheet?
How Can I Color Every Other Row in an Excel Spreadsheet?
How Can I Copy Selected Columns From a CSV File to an Excel File?
How Can I Change the Background Color of Spreadsheet Rows That Have a Date in a Specified Cell?
How Can I Export an HTA Table to Excel?
How Can I Delete All the Worksheets in a Spreadsheet Except for the First Worksheet?
How Can I Assign a Background Color to Cells in a Spreadsheet and Then “Sum” Those Cells?
How Can I Sort a Row in an Excel Spreadsheet?
How Can I Remove the Password When Opening an Excel Spreadsheet?
How Can I Import an Excel Spreadsheet Into an Access Database?
How Can I Save a Table in an Access Database as a Spreadsheet?
How Can I Use a Blank Row to Separate Data in an Excel Spreadsheet?
How Can I Specify the Number of Decimal Places to Display in an Excel Spreadsheet?
How Can I Configure Excel to Autosave Every 5 Minutes?
How Can I Save an Excel Chart as a Picture?
How Can I Change the Font Color in Excel If a Specified Condition is Met?
How Can I Convert an Excel Spreadsheet to XML?
How Can I Set the Default File Path in Excel to a User’s Home Directory?
How Can I Compare a List of Names in One Excel Column to a List of Names in Another Column?
How Can I Convert a Tilde-Delimited File to Microsoft Excel Format?
How Can I Search Active Directory for User Names Stored in an Excel Spreadsheet?
How Can I Add a Total Row to an Excel Spreadsheet?
How Can I Create a Custom Date Format in Microsoft Excel?
How Can I Keep the Screen From Updating While Running an Excel Script?
How Can I Use Information in an Excel Spreadsheet to Rename a Set of Folders?
How Can I Determine the Background Color of a Spreadsheet Cell?
How Can I Make the First Character in a Cell Uppercase and All the Other Characters Lowercase?
How Can I Copy a Worksheet to a New Spreadsheet?
How Can I Use Windows PowerShell to Automate Microsoft Excel?
How Can I Tell If a Specified Worksheet Exists in an Excel Workbook?
How Can I Add a COUNTIF Formula to an Excel Spreadsheet?
How Can I Copy All the Comments From an Excel Worksheet to a Word Document?
How Can I Change All the Lowercase Letters in an Excel Worksheet to Uppercase Letters?
How Can I Create a New Excel Spreadsheet at Midnight Each Night?
How Can I Select a Column of Data in Excel and Then Paste that Data into a Text File?
How Can I Convert a Number to a Date in Excel?
How Can I Locate and Replace Information for a Specific Item in a Spreadsheet?
How Can I Save an Excel Spreadsheet, and Then Save a Copy as HTML?
How Can I Format an Excel Spreadsheet So It Retains Leading Zeroes?
How Can I Determine the Last Row in an Excel Spreadsheet?
How Can I Remove All the Formatting from an Excel Spreadsheet?
How Can I Change the Footer in an Excel Spreadsheet?
How Can I Add Additional Worksheets to an Excel Workbook?
How Can I Sort Worksheets in a Workbook?
How Can I Import a Fixed-Width File into Microsoft Excel?
How Can I Add a Hyperlink to an Excel Spreadsheet?
How Can I Build an Array from a Column of Data in Excel?
How Can I Copy Column C of One Worksheet to Column A of a Second Worksheet?
How Can I Center Text in an Excel Cell?
How Can I Change the Background Color of a Cell Depending on the Date?
How Can I Delete Data from a Spreadsheet Yet Keep All the Formatting?
How Can I Open an Excel Workbook and Retrieve the Names of All the Worksheets?
How Can I Tell if an Excel Workbook is Open and, If It Isn’t, Open It?
How Can I Insert a Column into a Spreadsheet?
How Can I Save a Single Excel Worksheet to a CSV File?
How Can I Password-Protect an Excel Spreadsheet?
How Can I Make Changes to and Then Re-Save an Existing Excel Spreadsheet?

- Andrea Weiss