Ignoring Pop Up Messages

[wsf86]

Hi,

New user to this site, please help!!!!

I am running a excel macro which imports data from Access and display's it in a list. This refreshes automatically ever minute. The problem I am having is that when a record is deleted from Access a pop up box appears on excel and until this is acknowledged the excel macro will not refresh.

What I need is for this pop up box to either not appear at all or if it can be auto acknowledged.

Can anyone help?

Cheers

 

[Andrew Fergus]

Hello and welcome to MrExcel.

Try inserting the following line of code before the import step :

Application.DisplayAlerts = False

and include the following line after the import step :

Application.DisplayAlerts = True

More information on 'display alerts' is available here.

HTH, Andrew