Closing Excel error message from Access 2K

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

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
 
Hello Dave,

Via On Error function, you can bypass the message box.

Best Regards

Bill
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

close excel; leave access open 1
Error Message - Macro to Unlink MS Queries from Workbook 0
Run MS Excel Macro From MS Access 2
Run make table query from Excel with Access closed 2
Running an Access function (with parameters) from Excel 6
Access #Error & Excel Pivot 0
Closing Excel When Using CreateObject to Open It 2
Excel Run-time error '1004' General ODBC Error 1

Back
Top