how do i suppress notify "File not available"?

E

Eddy Kwan

I used the excel automation.

Before i open the workbook, I set DisplayAlerts = False and visible = false
then I open the workbook with

Workbooks.Open(fileName:=Filename)

check the readonly flag, if readonly is true, i close the workbook and
reopen with
Workbooks.Open(fileName:=Filename, readonly:=true)

some time later, If someone close the workbook, I got the notification with
file not available and my app lock-up.

How do i suppress this notification?
 
E

Eddy Kwan

Even I open the workbook with
Workbooks.Open(fileName:=Filename, Notify:=false)

it doesn't help
 

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

Top