使用宏时的错误问题

来源:百度知道 编辑:UC知道 时间:2024/07/04 02:15:57
打开EXCEL文件 提示启用宏 启用后提示 [运行时错误“75”,路径/ 文件访问错误] 调试时指出问题程序:
SetAttr ThisWorkbook.Path & "\grxi.xls", vbNormal

本人对程序不通 请高手指点!!!

Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Dim w As Workbook
For Each w In Workbooks
If w.Name <> ThisWorkbook.Name Then
w.Close savechanges:=True
End If
Next w
Set w = Nothing

End Sub

Private Sub Workbook_Open()
Application.Visible = False
SetAttr ThisWorkbook.Path & "\grxi.xls", vbNormal
SetAttr ThisWorkbook.Path & "\sj.xls", vbNormal
Workbooks.Open ThisWorkbook.Path & "\grxi.xls", , , , 32351, 32351
Workbooks.Open ThisWorkbook.Path & "\sj.xls", , , , 32351, 32351
Set yiyaoworkbook = Workbooks("grxi.xls")

ThisWorkbook.Activate

SetAttr ThisWorkbook.Path & "\grxi.xls", vbNormal
高深的我也不懂,不过这句提示出错
ThisWorkbook.Path & "\grxi.xls"意思就是本工作簿目录下的grxi.xls文件,你没有这个文件