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.
|