|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 liuxi001 于 2019-6-28 13:17 编辑
- Sub Macro2()
- Dim fd As FileDialog, wb As Workbook, sh As Worksheet, d As Object
- Set d = CreateObject("scripting.dictionary")
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- For Each sh In Sheets
- If sh.Name <> ActiveSheet.Name Then sh.Delete
- Next
- Set wb = ThisWorkbook
- Set fd = Application.FileDialog(msoFileDialogFilePicker)
- fd.InitialFileName = ThisWorkbook.Path & ""
- With fd
- .Title = "请选择要合并的xls文件"
- If .Show = True Then
- For Each vrtselecteditem In .SelectedItems
- If InStr(vrtselecteditem, Left(wb.Name, InStrRev(wb.Name, ".") - 1)) = 0 Then
- With Workbooks.Open(vrtselecteditem)
- tmp= .Sheets("学生学籍信息表").[a3:bz3].value
- wb.Activesheet.[a65536].End(xlUp).Offset(1).resize(1,ubound(tmp,2))=tmp
- erase tmp
- .Close False
- End With
- End If
- Next
- End If
- End With
- Sheets(1).Activate
- Application.ScreenUpdating = True
- MsgBox "ok"
- End Sub
复制代码 |
|