This article on MSDN gives a great overview of how to work with the Excel object model in a Visual Studio 2005 Tools for Office project.