View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default On error resume next

I have always used "Break on Unhandled Errors". I've not use very many Class
Modules in my coding across the years... does "Break in Class Module" work
the same way outside of the Class Module as "Break on Unhandled Errors" (the
Help file is not very clear on this point)?

--
Rick (MVP - Excel)


"Dave Peterson" wrote in message
...
You still have major syntax errors.

It's better to copy directly from the VBE and paste into your message.

That said, try this:

Inside the VBE
Tools|Options|General tab|check "break in class module"

(I'm guessing that you have break on all errors checked.)

Johan wrote:

Rick Rothstein skrev:

Your code cannot look like you posted... VB would tag the three lines
between the On Error statements as invalid syntax. Why don't you show
us
what you are actually executing so we can see what you trying to do.

--
Rick (MVP - Excel)


"Johan" wrote in message
...
I have a macro which call other macroes.
In the end of the code it "cleans up" with the following code:

on error resume next
c:\arbeidsliste\sjekk.txt
c:\arbeidsliste\sjekk.bat
c:\arbeidsliste\send.bat
on error goto 0

The problem is that if one of the file is missing the code stop and
display
error message.

Any one have a solution?

Johan

Sorry I did some error in my typing, the code is:

on error resume next
kill c:\arbeidsliste\sjekk.txt
kill c:\arbeidsliste\sjekk.bat
kill c:\arbeidsliste\send.bat
on error goto 0

Johan



--

Dave Peterson