数据copy到本工作薄内的另一个表中:
Sub copy_sheet()
Cells.Select
Selection.Copy
Sheets("Sheet2").Select
Range("A1").Select
ActiveSheet.Paste
Range("A1").Select
End Sub
数据copy到其他工作薄的表中:
Sub copy_sheet()
wb1 = ActiveWorkbook.Name
Application.FileDialog(msoFileDialogFilePicker).Filters.Add "Excel(*.xls)", "*.xls", 1
temp = Application.FileDialog(msoFileDialogFilePicker).Show
If temp <> 0 Then
Application.Workbooks.Open (Application.FileDialog(msoFileDialogFilePicker).SelectedItems(1))
End If
wb2 = ActiveWorkbook.Name
Workbooks(wb1).Activate
Sheets(1).Activate
Cells.Select
Selection.Copy
Workbooks(wb2).Activate
Sheets("Sheet2").Activate
Range("a1").Select
ActiveSheet.Paste
Range("a1").Select
Workbooks(wb2).Save
Workbooks(wb2).Close
End Sub