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

Excel TWO Instances of Excel One watching Other 3
Getting #ref error after row / cell is this a limit in excel 2003 tiasal2 2
Getting rid of update links popup? 3
software restriction policy - suppress popup ? 16
How to get Popup Text help to work 3
Windows 10 How to get rid of lines on documents 2
How can I PERMANENTLY get rid of the Excel clipboard? 2
now available for editing 1

Back
Top