I have some code here, but for some reason I can't get it to work properly.
tempExcel.ActiveWorkbook.Sheets(1).Copy( _
After:=oExcel.ActiveWorkbook.Sheets(3))
I could copy from one worksheet to another worksheet on the same workbook, but if I execute the code above in which I am copying one workbook to another different workbook, I get an error saying "Copy method of Worksheet class failed."
I would like to copy from tempExcel workbook, worksheet 1 to oExcel workbook, worksheet 1.