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

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

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

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

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

I saved this from a Chip Pearson post:

In general, it is better to use "Break In Class Module" rather than "Break
On Unhandled Errors". With break in class module, you'll enter debug mode on
the exact line within a class that caused the problem. With break on
unhandled errors, you'll break on the code that called the method of the
class, which is of little use for debugging. Of course, this is irrelevant
if you don't have code in any classes.



Rick Rothstein wrote:

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

--

Dave Peterson