|
本帖最后由 liuts 于 2011-4-10 13:44 编辑
Sub Macro3()
Application.DisplayAlerts = False
ActiveWorkbook.Save '先保存目标文件
Dim FilesToOpen
Dim X As Integer
Dim i As Integer
Dim Mname As String
Dim Oname As String
Application.ScreenUpdating = False
Mname = ActiveWorkbook.Name '目标文件名
FilesToOpen = Application.GetOpenFilename(FileFilter:="MicroSoft Excel文件(*.xls),*.xls", Title:="", MultiSelect:=True) '在此导入的EXCEL2007文件,扩展名在这里可自己指定
If TypeName(FilesToOpen) = "Boolean" Then
MsgBox "没有选中文件"
Exit Sub
End If
X = 1
While X <= UBound(FilesToOpen)
Workbooks.Open Filename:=FilesToOpen(X)
With ActiveWorkbook
Oname = .Name '源文件名
Workbooks(Oname).Sheets("汇总").Select
Application.WindowState = xlMinimized
ActiveWindow.SmallScroll Down:=-39
Range("A8:FX8").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Windows("全部单位汇总.xls").Activate
Sheets("汇总").Select
Range("a8").Select
If Range("a8") = "" Then
GoTo 100
End If
Selection.End(xlDown).Select
X = Selection.Row + 1
Cells(X, 1).Select
100:
Selection.Insert Shift:=xlDown
.Close '源文件关闭
X = X + 1
End With
Wend
Application.DisplayAlerts = True
End Sub
按照我的理解,应该能够达到你的要求。 |
|