|
复制粘贴啊,这个简单:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
fn = Application.GetOpenFilename("Excel文件(*.xlsx;*.xls),*.xlsx;*.xls")
If Len(fn) > 0 Then
Set wb = Workbooks.Open(fn)
wb.Worksheets(1).Range(wb.Worksheets(1).Cells(7, 2), wb.Worksheets(1).Cells(wb.Worksheets(1).[b10000].End(3).Row, 13)).Copy
ThisWorkbook.Worksheets(1).Activate
Range("a" & [a100000].End(3).Row + 1).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
wb.Close False
End If
Application.DisplayAlerts = True
Application.ScreenUpdating = True
|
评分
-
查看全部评分
|