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
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