Sub OpenF()Dim name, mypathname = "sox.xlsx"mypath = "D:\nt\hist\" & nameIf Dir(mypath, vbNormal) <> "" Then MsgBox "Open 文件"Else MsgBox "找不到此文件,请确认输入是否正确" Exit SubEnd IfEnd Sub
msgbox “找不到此文件,请确认输入是否正确”On Error Resume Nextexit sub