Convert Numbers to Excel Column Names

• Working with Excel Workbooks and Worksheets in E-Mail Microsoft Excel MVP Ron de Bruin provides a number of samples and a handy add in that enhances your experience when working with e mail from E ...

• Excel 2007 Week Numbering Systems and DateTime Implementations Learn about the four different week numbering systems available in Microsoft Office Excel and how to use them Also learn why it is important to implement the date and time representation of the ISO8601 2000 standard in your Excel applicat ...

• Video: Visual How to: Office Open XML Formats: Retrieving Excel 2007 Cell Values Demonstrates how to retrieve values from an Excel 2007 works ...

• Video: Visual How to: Using Office Open XML File Formats to Retrieve a List of Excel 2007 Worksheets Describes how to retrieve a list of worksheets in Excel ...

• OfficeTalk: Conditional Formatting: Adding Customized Rules to Excel 2007 The conditional formatting user interface UI in Excel 2007 now makes it easier than ever to create rules that increase the impact of your data Learn how to take advantage of the powerful conditional formatting options from the UI and programmatic ...

• Visual How to: Office Open XML Formats: Retrieving Excel 2007 Cell Values Describes how to retrieve information about a specific cell within an Excel workbook or set of workbooks using Office Open XML For ...

• Visual How to: Use Office Open XML File Formats to Retrieve a List of Excel 2007 Worksheets Describes how to retrieve a list of all the worksheets within an Excel workbook or set of workbooks using Open XML File For ...

• Enterprise Reporting with Excel Microsoft Office Excel 2007 version lifts several of the limitations in previous versions making Excel reporting even more powe ...

• Data Points: Column Expressions, DataRelations, and Computations This month John Papa fields some of his favorite questions regarding data manipulation with ADO ...

• Display Web Service Type in a Table Column After you ve dropped a web service method onto a table you may want to change what the table displays David Botterill blogs on how to find and change the quot; types quot; retu ...