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

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 wrote:

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

Hi, Dave
Thank you much

"Dave Peterson" wrote:

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 wrote:

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