View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Adrian[_11_] Adrian[_11_] is offline
external usenet poster
 
Posts: 2
Default ActiveWorkbook.SaveAs - dealing with file already exists

Thank you, Patrick. The "dir" function achieves what I wanted. I knew
that there should be such a function but I could not find it.

Also, to Arvi, I will study Application.FileSearch and the rest of the
code that you posted.