View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
karmela karmela is offline
external usenet poster
 
Posts: 9
Default test file - is open?

Hi,
I made a macro which does some changes in the workbook and saves it with a
new name. But I forgot one possible error - the file with the new name still
exists, macro will rewrite it. Someone in network can have opened it at the
moment I want do rewrite.
Is there possibility of testing, if the file is able to rewrite? I don!t
want to go through Error Statement.

Thanks

karmela