C# - how do I copy Excel Worksheet from one Workbook to another?
Posted on 2010-01-08
Does anyone have C# code that copies an Excel worksheet from one workbook to another? I'm using Office 2003 and Visual Studio 2005. I have VSTO 2005 SE installed and am interested in using the Microsoft.Office.Tools.Excel object instead of the convoluted Excel Interop object. I've been trying to get some VBA examples that I see on the 'net to work (obviously not using VSTO), but can't get that to work, nor anything I try with VSTO.