LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 32
Default comparison of 2 approaches for identifying file existence

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...

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Check existence of file if file name has a space in it. mc Excel Programming 3 September 30th 08 07:39 PM
Check File Existence Catalin[_2_] Excel Programming 5 May 10th 06 10:20 AM
Test for file existence Joseph[_46_] Excel Programming 1 November 12th 04 08:56 PM
Test for file existence Joseph[_45_] Excel Programming 1 November 12th 04 04:04 PM
Vba - Checking existence of file ajliaks[_26_] Excel Programming 1 August 11th 04 06:43 PM


All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"