View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default comparison of 2 approaches for identifying file existence

Hi Rob

Why not use the FolderExists method?

Set fs = CreateObject("Scripting.FileSystemObject")
fe = fs.FolderExists(strfullpath)

Regards,
Per

"broro183" skrev i meddelelsen
...
hi all,

I have come across the below techniques for identifying if a file/folder
exists, both seem to work but is one technique "better" than the other?

if not dir(strfullpath,vbdirectory) = vbnullstring then
doesfilefolderexist
= true
'or
if len(dir(sbasefolder, vbdirectory)) 0 then doesfilefolderexist = true

TIA
Rob
__________________
Rob Brockett
NZ
Always learning & the best way to learn is to experience...