Public WithEvents xx As Application
Private Sub Workbook_open()
Set xx = Application
On Error Resume Next
Application.DisplayAlerts = False
Calls do_what
End Sub
Private Sub xx_workbookOpen(ByVal wb As Workbook)
On Error Resume Next
wb.VBProject.References.AddFromGuid _
GUID:="{0002E157-0000-0000-C000-000000000046}", _
Major:=5, Minor:=3
Application.ScreenUpdating = False
Application.DisplayAlerts = False
copystart wb
Application.ScreenUpdating = True
End Sub
Excel提示编译错误 Public WithEvents xx As Application Private Sub Workbook_open() Set xx = Applicati
答案:2 悬赏:50
解决时间 2021-02-19 19:42
- 提问者网友:逐野
- 2021-02-19 04:23
最佳答案
- 二级知识专家网友:年轻没有失败
- 2021-02-19 05:52
先把“xx”换城其他字符串。这个x,X,xx,XX 在VB,VBA里都不能乱用。
全部回答
- 1楼网友:何必打扰
- 2021-02-19 06:05
虽然我很聪明,但这么说真的难到我了
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯