Dec 30, 2009 06:49 AM|singhmanish_888|LINK
I tried with WorkSheet.Move() function to check the behavior for the case but it is resulting the same as WorkSheet.Copy().Ideally Move() should completely move sheets from one workbook to another.If you try it manually on excel files and record a macro
it displays Move() function and work properly but from C# the same behavior is not working.
I found a article where stated that Excel maintains a clipboard while doing all operation on windows but C# doesn't consider any clipboard.
I am still finding an appropriate way to do this using C#.Maybe some experts can help us on this.