Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ON ERROR
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 a 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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ON ERROR
On Error only handles trappable errors. If Excel crashes, that isn't
trappable by VBA. Regards, Tom Ogilvy "Honza" wrote in message ... 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 a 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
ON ERROR
Thanks. I see.
I need to manage kill the excel to my main BATCH file could continue with Another Excel task ... There should run another check program which would check if Excel does not crashed. If so, then kill the Excel. How I can control that Excel crashed - Status of excel? Thanks for help. Regards Honza *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 - error saving file & error loading dll | Excel Discussion (Misc queries) | |||
Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) |