Copy Excel Worksheet

[cjohnson]

I have a program (VB.Net 2005) that opens several Excel workbooks and updates information. I have figured out all but the last step. I need to copy an entire worksheet from one workbook to another. Here is what I am trying:

oSheet11.Copy(Before:=oSheetR1)

oSheet11 is the worksheet I want to copy, and I want it placed before oSheetR1 in another workbook. Can anyone tell me why this code doesn't work?
Thanks