View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Township of East Hanover Township of East Hanover is offline
external usenet poster
 
Posts: 31
Default Check a file in a directory

Path = "driverletterhe\directoryhere\filenamehere"
If Len(Dir(Path)) = 0 Then


"Rich Cooper" wrote in message
...
I am trying to have excel file check to see if another excel files is a
directory. If it is i want it to call it and run that file. But if that
file is not i want it to continue on. Any help on how to do this would be
great.