C# .NET - C# interfacing with excel

I am using C# in microsoft visual studuo 2008. have been succesfully interfacing with excel 2003 via the use of

using Excel = Microsoft.Office.Interop.Excel;

and of course the common commands.

now my work suddently decided that all computers need to be updated to office 2010 package. and i now get a error message:
The type or namespace name 'Office' does not exist in namespace 'Microsoft' (are you missing a namespace reference?)

when i start typing in "Microsoft." in the code i get options of what can come next, "Office" is not included there. what do i need to change in my code to make everything work again with office 2010? 

Thanks for your assistance

If you open up your Add Reference dialog you should see a number of Interop.Exel assemblies that you can set a reference to.

Hi please follow the Steps given below
Add a reference to the Microsoft Excel Object Library. To do this, follow these steps:

1. On the Project menu, click Add Reference.
2. On the COM tab, locate Microsoft Excel Object Library, and click Select.
   
   Note Microsoft Office 2003 includes Primary Interop Assemblies (PIAs). Microsoft Office XP does not include PIAs, but they can be downloaded. For more information about Office XP PIAs, click the following article number to view the article in the Microsoft Knowledge Base:
   http://support.microsoft.com/kb/328912  (http://support.microsoft.com/kb/328912/%20) Microsoft Office XP primary interop assemblies (PIAs) are available for download
3. Click OK in the Add References dialog box to accept your selections. If you are prompted to generate wrappers for the libraries that you selected, click Yes.

Please refer this link for any information regarding the http://msdn.microsoft.com/en-us/library/ms173186%28v=vs.80%29.aspx#Y342 .dll.
Hope this will help you:-)

For your problem, first add these reference in your project-

Microsoft.Office.Interop.Excel.

for this right click on project and clieck on add reference-

add AddReference->.NET->Microsoft.Office.Interop.Excel.

for more deila follow this-
http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/201ebd48-c24c-418b-afec-b799b6222f30/

 

 

To add references to the Excel 2010 primary interop assembly

Thank you everyone for your prompt and useful reply. :)