ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Run-time error'70' (https://www.excelbanter.com/excel-discussion-misc-queries/226852-run-time-error70.html)

danpt

Run-time error'70'
 
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

Run-time error'70'
 
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

danpt

Run-time error'70'
 
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



All times are GMT +1. The time now is 12:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com