|
我有一个小需求 做一个EXCEL宏 点击之后它可以打开所在文件夹里的所有EXCEL文件,复制第二列内容,依次粘帖到我这个带宏的EXCEL里
我自己写的,没能实现 求帮忙
Sub 按钮1_Click()
Application.ScreenUpdating = False
Dim filename As String
Dim bw As String
Dim mypath As String
mypath = ThisWorkbook.Path
filename = Dir(mypath, vbNormal)
Do While filename <> ""
filenames = Dir
bw = filename
Workbooks.Open filename:=ThisWorkbook.Path & "\" & "bw.XLSm"
Range("C1:C200").Copy
Windows("汇总.xlsM").Activate
i = 1
cell(1, i).Select
ActiveSheet.Paste
Windows("bw.xlsm").Close
i++
Loop
Application.ScreenUpdating = True
End Sub
- Sub 按钮2_Click()
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Dim filename As String
- Dim mypath As String
- mypath = ThisWorkbook.Path & "\*.*xl*"
- filename = Dir(mypath, vbNormal)
- Do While filename <> ""
- If filename = "汇总.xlsm" Then GoTo 100
- Workbooks.Open filename:=ThisWorkbook.Path & "" & filename
- Range("C1:C200").Copy
- Windows("汇总.xlsM").Activate
- i = i + 1
- Cells(1, i).Select
- ActiveSheet.Paste
- Windows(filename).Close
- 100:
- filename = Dir
- Loop
- Application.DisplayAlerts = True
- Application.ScreenUpdating = True
- End Sub
复制代码不好意思 汇总.xlsM应改成汇总.xlsm
|
|