|
楼主 |
发表于 2010-3-24 12:07
|
显示全部楼层
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
原帖由 lb_bn 于 2010-3-24 11:33 发表
application.run yourbookname & "!" yourmacro , x , y
不知是不是以下这样,但还是不行!!!
Sub 批量执行Macro1()
Dim mypath$, myFile$, AK As Workbook
On Error Resume Next
mypath = ThisWorkbook.Path & "\分表\"
myFile = Dir(mypath & "*.xls")
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Do While myFile <> ""
Set AK = Workbooks.Open(mypath & myFile)
Application.Run AK & "!" & macro1 ', x, y
AK.Close True
myFile = Dir '找寻下一个*.xls文件
Loop
Application.DisplayAlerts = True
Application.ScreenUpdating = True
MsgBox "执行完毕,请查看!", 64, "提示"
End Sub |
|