Run-time error'70'

D

danpt

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

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.
 
D

danpt

Hi, Dave
Thank you much

Dave Peterson said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top