priate sub test1() dim xlapp as new excel.application dim xlsheet as excel.worksheet xlapp.workbooks.open "excel文件路径" set xlsheet=xlapp.workbooks(1).Sheets.Add xlapp.workbooks(1).Sheets("Sheet1").Select xlapp.workbooks(1).Cells.Select xlapp.Selection.Copy xlsheet.Select xlapp.ActiveSheet.Paste xlapp.close set xlapp=nothing end sub
dim xlapp as new excel.application
dim xlsheet as excel.worksheet
xlapp.workbooks.open "excel文件路径"
set xlsheet=xlapp.workbooks(1).Sheets.Add
xlapp.workbooks(1).Sheets("Sheet1").Select
xlapp.workbooks(1).Cells.Select
xlapp.Selection.Copy
xlsheet.Select
xlapp.ActiveSheet.Paste
xlapp.close
set xlapp=nothing
end sub