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

Comments

• Anonymous
  January 01, 2003
  PingBack from http://amdtalk.com/1969/office-resource-kit-blog-hey-scripting-guy-scripts-for/

• Anonymous
  June 07, 2015
  Hi Scripting Guy...
  I have a excel workbook, in this workbook i have number of sheets,( say 8 to 10 sheets) i want copy all the data from these sheets and paste in new sheet of new workbook, like first Sheet1 data, after sheet2 data....likewise.
  Thanks...