Dim App As New MSExcel.Application Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open("D:\test.xls") Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1) Dim Rg1 As MSExcel.Range = Ws.Range("A1:B5") rg1.Copy Dim Rg2 As MSExcel.Range = Ws.Range("A6:B10") rg2.Select ws.paste app.Visible = True