View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Checking to see of a folder exists

I've used this before, but it's untested, uncompiled here.

Dim TestStr as string
teststr = ""
on error resume next
teststr = dir("\\your\unc\path\here" & "\nul")
on error goto 0

if teststr = "" then
'not there
else
'is there
end if



Chuck M wrote:

Hi,

I'm using a DIR command to verify that a folder exists on a local C: drive.
If I need to check a folder on a network drive, can I use the mapped drive
letter or must I supply a UNC path to the DIR command. I don't have the
resources to test this myself.

TIA
--
Chuck M.


--

Dave Peterson