Hi,

I want to open an already existing workbook and import one of its sheets into a different already running workbook (I need to remap the data from one worksheet into a set of others). But when I open the *.xls file using the Workbooks.Open() method I get a remoting proxy to a different instance of excel. Is their a way to open the workbook in the already running instance, so that I can just grab the worksheet I want and deal with it. Without having to go through all of the remoting issues.

Thanks,

blair

Hi,

Ok I figured out how to do this but it really seems to be a hack, code below:

Excel.Workbook externalWorkbook = this.Application.Workbooks.Open(aFinder.FileName, 0, true, missing, missing, missing, true, missing, missing, missing, missing, missing, missing, missing, missing);

Excel.Sheets sheets = externalWorkbook.Sheets;

Excel.Worksheet aSheet = sheets.get_Item(1) as Excel.Worksheet;

aSheet.Copy(Globals.Sheet1.InnerObject, missing);