|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub 数据提取()
- If MsgBox("确定更新数据?", vbYesNo + vbExclamation, "提示") = vbNo Then Exit Sub
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- Dim WB As Workbook, sSht As Worksheet, dSht As Worksheet
- Dim GZT As Worksheet
- Set GZT = ThisWorkbook.Worksheets("工作台")
- Dim basePath, sFullPath
- basePath = ThisWorkbook.Path
- For i = 3 To 5
- sFullPath = basePath & "" & GZT.Cells(i, 2)
- Set WB = Workbooks.Open(sFullPath)
- Set sSht = WB.ActiveSheet
- Set dSht = ThisWorkbook.Worksheets(GZT.Cells(i, "E").Value)
- dSht.Cells.ClearContents
- sSht.UsedRange.Copy dSht.[a1]
- WB.Close False
- Next i
- Application.ScreenUpdating = False
- Application.DisplayAlerts = False
- MsgBox "更新完成", vbOKOnly + vbInformation, "提示"
- End Sub
复制代码
查收附件
总部配送价合并.zip
(49.54 KB, 下载次数: 15)
|
|