Thread: IF File Exists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] Ralph.Hill@siemens.com is offline
external usenet poster
 
Posts: 2
Default IF File Exists

I am writing a macro and have run into 2 problems.

FIRST: How can I validate that a a File "MyFile"
exists, and if the file does NOT exist, then exit the
procedure.

SECOND: if the File exists and is empty I want
advise the user.