How to get rid of this popup ?

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

Hi,

In my application I am trying to import data that is available in an excel
sheet to another database (MS Access), the whole process is working fine
apart from the pop up message that is being displayed by Excel stating that
document is now available for editing . Choose Read-Write to open it for
editing.

It will be nice if someone could guide me in a way where this pop-up message
can be avoided.

TIA,
Gary
 
Have you tried using the Alerts option ? eg:

Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
 
Back
Top