View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MacroMan[_4_] MacroMan[_4_] is offline
external usenet poster
 
Posts: 1
Default Verify a directory exists

I hope someone can help me with this. I am using VBA in
Excel XP with Windows 2000.

I am working with a legacy program in which the user
supplies a network path (e.g. \\col-gs1\subdir\temp\).

I cannot change the program other than to add a subroutine
that will verify that the user-supplied path is valid and
actually exists. This path is also typically empty, so I
can't look for any particular file either.

I know there are better ways to accomplish getting a path
from a user, but I must work within boss's constraints.

Your example code would be most appreciated. Thanks in
advance.