View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] robinson.william@gmail.com is offline
external usenet poster
 
Posts: 5
Default How to determine if a Folder/Directory Exists in Excel VBA

Hi All,

Does anybody know how i can determine if a directory exists in VBA? For
example i would like to write a function that looks to see if the path
c:\reports\2006 exists, if so leave it be, if not create it.

Thanks,
Bill