| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Closing Excel error message from Access 2K
I have a timed event,in Access that opens an excel sheet. Sometimes the
opening of the excel sheet fails and an Excel message box appears saying "unable to read file". This then stops further code running in my Access database. What I want to be able to do is to close down the excel message, from Access so further code can run. Can anyone help me? Thanks in advance Dave BT Wholesale UK |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Closing Excel error message from Access 2K
Hello Dave,
Via On Error function, you can bypass the message box. Best Regards Bill -----Original Message----- I have a timed event,in Access that opens an excel sheet. Sometimes the opening of the excel sheet fails and an Excel message box appears saying "unable to read file". This then stops further code running in my Access database. What I want to be able to do is to close down the excel message, from Access so further code can run. Can anyone help me? Thanks in advance Dave BT Wholesale UK . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message when opeing and closing excel | Excel Worksheet Functions | |||
| Error message adaytum.xla when closing workbook in Excel 2003 | Excel Discussion (Misc queries) | |||
| error message "excel cannot access office" | Excel Discussion (Misc queries) | |||
| Error message in Excel after exporting Access query to Excel | Excel Discussion (Misc queries) | |||
| Unexpected error message on closing an Excel file | Excel Discussion (Misc queries) | |||
![Dave[_23_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
