View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Cresta Cresta is offline
external usenet poster
 
Posts: 76
Default Check if a file is already open

Hello all
Is there any way to check if a file is already open by another user before
trying to open it.

If "Filename is open" = true then
abort procedure
else
Workbooks.Open Filename....
end if

Thanks