Run-time error'70'

[danpt]

Is there a way to get pass a Run-time error'70': Permission denied ?
Something like If Error = Error(9) then goto skip

 

[Dave Peterson]

on error resume next
'the thing that causes the error
if err.number <> 0 then
if err.number = 70 then
msgbox "it's 70"
else
msgbox "it's not 70, but it is an error"
end if
err.clear
end if
on error goto 0

may be one way.

 

[danpt]

Hi, Dave
Thank you much

on error resume next
'the thing that causes the error
if err.number <> 0 then
if err.number = 70 then
msgbox "it's 70"
else
msgbox "it's not 70, but it is an error"
end if
err.clear
end if
on error goto 0

may be one way.