Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Guys
I need to copy data from an uploaded excel into master excel . I'm doing this but the excel objects are not getting cleaned up. I see 2 instances of Excel running in 'Task Manager'. Whats the best way to copy range of data from one excel workbook to other workbook. HEre is my code; Excel.Application srcExcel = new Excel.ApplicationClass(); Excel._Workbook srcWb = srcExcel.Workbooks.Open(fName, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); Excel._Worksheet srcWsh = (Excel._Worksheet)srcWb.Sheets.get_Item(2); Excel.Application dstExcel = new Excel.ApplicationClass(); Excel._Workbook dstWb = dstExcel.Workbooks.Open(eventdir, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); Excel._Worksheet dstWsh = (Excel._Worksheet)dstWb.Sheets.get_Item(2); // following seems to work but excel objects are not getting cleaned up ((Excel.Range)dstWsh.get_Range("C4", "N26")).Value2 = ((Excel.Range)srcWsh.get_Range("C4", "N26")).Value2; // this one gives error. //Excel.Range r1 = (Excel.Range)srcWsh.get_Range("C4:N26", Type.Missing); //Excel.Range r2 = (Excel.Range)dstWsh.get_Range("C4:N26", Type.Missing); //r2.Value2 = r1.Value2; //r1.Copy(r2); pl help. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 SP3 Copy Worksheet with another sheet named range now # | Excel Discussion (Misc queries) | |||
Excel VBA Paste of Range with PrefixCharacter fails from VB.NET | Excel Discussion (Misc queries) | |||
How do I edit a selected range then copy the range into an new sheet??? | Excel Programming | |||
sheet copy method fails... | Excel Programming | |||
Copy to another sheet fails | Excel Programming |