Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel shuts down after opening dialog
After my vba code (below) displays the SendMail dialog and the email is
sent, Excel displays the message "Excel has encountered a problem and will shut down". Excel then shuts down and restarts. Does anyone know why and how to prevent Excel from shutting down? Thanks. If MsgBox("Would you like to attach the Sample Report Request to an email now?", vbYesNo) = vbYes Then Application.Dialogs(xlDialogSendMail).Show Else End If End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel shuts down after opening dialog
This occurs when Excel encounters an error from which it can't recover. the
obvious answer would be to figure out what is causing it to encounter the error. Does it encounter the error when you perform this action manually? -- Regards, Tom Ogilvy "JG Scott" wrote in message ups.com... After my vba code (below) displays the SendMail dialog and the email is sent, Excel displays the message "Excel has encountered a problem and will shut down". Excel then shuts down and restarts. Does anyone know why and how to prevent Excel from shutting down? Thanks. If MsgBox("Would you like to attach the Sample Report Request to an email now?", vbYesNo) = vbYes Then Application.Dialogs(xlDialogSendMail).Show Else End If End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening Excel - getting print dialog box | Excel Discussion (Misc queries) | |||
Excel 2000 shuts down after opening file | Setting up and Configuration of Excel | |||
how do i create a dialog box to appear on opening an excel wkbook | Excel Discussion (Misc queries) | |||
Running Dialog Sheet when opening Excel File | Excel Programming | |||
Opening a new mail dialog box in Excel using vba | Excel Programming |