How to use C# 2010 with Excel 2007
I am using VS 2010 and Excel 2007. I am new to using C#. Is it possible to create an app that can be saved on my desktop that can be used with an excel file that is saved on my desktop? I have opened VS 2010 and I have created a form design that has a button for every sheet name in my excel file. All of the sheet names are hidden with the exception of one. When a button is pressed on the c# form, I would like for that sheet to be shown in excel. Then once the updates have been made to that sheet in excel, I want a button to be at the top of the excel worksheet that will hide that worksheet again and return to the form c# form...can that be done?
Re: How to use C# 2010 with Excel 2007
Yes it can be done.
Have a look into Office automation ;)