H
Honza
I have a following problem.
From Batch file runs VBS from VBS runs Excel and its Macro
code in VBA creates pivot table and at the and close
itself.
Sometimes appears an Error: Windows with ERROR information
and Check box "Recover my work and restart Excel Two
Bottoms "Send Error Report" and "Don't Send"
This cause that The Excel stay in this state and it needs
Manual interaction.
My questions are:
Why this described message appeared Even though I have
switched on "ON ERROR GOTO .." in VBA Macro ?
How to manage to do not display this Error message and
control errors in VBA?
From Batch file runs VBS from VBS runs Excel and its Macro
code in VBA creates pivot table and at the and close
itself.
Sometimes appears an Error: Windows with ERROR information
and Check box "Recover my work and restart Excel Two
Bottoms "Send Error Report" and "Don't Send"
This cause that The Excel stay in this state and it needs
Manual interaction.
My questions are:
Why this described message appeared Even though I have
switched on "ON ERROR GOTO .." in VBA Macro ?
How to manage to do not display this Error message and
control errors in VBA?