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

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


.