|
本帖最后由 asd1220 于 2018-4-8 14:45 编辑
设置的代码如下
- Sub Sum_up()
- Dim bt As Range, r As Long, c As Long
- r = 1 '定义行数
- c = 7 '定义列数
- Dim rt As Worksheet
- Set rt = ThisWorkbook.Worksheets(1) '将汇总表的赋予变量rt
- rt.Rows(r + 1 & ":1048576").ClearContents '清空数据只保留表头
- Application.ScreenUpdating = False
- Dim rfilename As String, rsht As Worksheet, rwb As Workbook
- Dim rrow As Long, rfn As String, rarr As Variant
- rfilename = Dir(ThisWorkbook.Path & "\*.xls")
- Do While rfilename <> ""
- If rfilename <> "报名填写" Then
- rrow = rt.Range("B8").CurrentRegion.Rows.Count + 1 '获取数据
- rfn = ThisWorkbook.Path & "" & rfilename
- Set rwb = GetObject(rfn)
- Set rsht = rwb.Worksheets(1)
- rarr = rsht.Range(rsht.Cells(r + 1, "A"), rsht.Cells(1048576, "B").End(xlUp).Offset(0, 6))
- rwt.Cells(rrow, "A").Resize(UBound(rarr, 1), UBound(rarr, 2)) = rarr
- rwb.Close False
- End If
- rfilename = Dir
- Loop
- Application.ScreenUpdating = True
- End Sub
复制代码
然后运行时报错提示需要对象
程序断在
- rwt.Cells(rrow, "A").Resize(UBound(rarr, 1), UBound(rarr, 2)) = rarr
复制代码
求助怎么修改啊
相关文件也都在同一个文件夹里面
我想实现的功能是把工作簿.xls里面拷贝数据
范围B列到G列,从第8行开始,拷贝所有有效信息
新建文件夹.rar
(19.68 KB, 下载次数: 4)
|
|