Extend coded UI tests and action recordings
The testing framework for coded UI tests and action recordings does not support every possible user interface. It might not support the specific UI that you want to test. For example, you cannot immediately create a coded UI test or an action recording for a Microsoft Excel spreadsheet. However, you can create your own extension to the coded UI test framework that supports your specific UI by taking advantage of the extensibility of the coded UI test framework.
Sample extension to test Microsoft Excel
The sample is intended for use with Microsoft Excel 2010. It may or may not work with other versions of Excel.