View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
abdrums abdrums is offline
external usenet poster
 
Posts: 7
Default Check if file exists...

I use the following to save a file to folder. How can I have it check
to see if the filepath exists and it exits then msgbox indicated that file
is there and exit sub routine, and if not exists, go ahead and create the
path?

ActiveWorkbook.SaveAs Filename:="\\my path directory\" & NewFileName & ".xls"