View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How to validate path? --- bValidatePath ("") Then

You would not get an error. Dir(path) would simply return "" if the path
being sought were not available.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"dim" wrote in message
...
Hi,

GTV, I didn't try your way, because if the user has the files installed in
a
harddrive designated 'D', then I think your first If statement would
return
an error since there may be no C drive present at all. But thankyou.

Roger, I tried you way and thus far it's working, but I haven't
transferred
the files onto the other computer with the D drive to test it yet, but it
executes fine on my C drive with the code inserted for both.

Thankyou both for your help. Its appreciated.