how do i suppress notify "File not available"?

  • Thread starter Thread starter Eddy Kwan
  • Start date Start date
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?
 
Even I open the workbook with
Workbooks.Open(fileName:=Filename, Notify:=false)

it doesn't help
 
Back
Top