Thread: checking path
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default checking path

Hi Norman,

Thank you for your reply! I checked Ron de Bruin's ExistFolder, but it has
the same problem: doesn't work (returns a wrong False value) if path to be
checked consists of only the server name.

My aim is to separate cases of non-existence of a folder:

1. The folder doesn't exist on an existing server.
2. The folder doesn't exist because the server itself doesn't exist (e.g.
its name is mis-spelled).

Any idea?

Regards,
Stefi

€˛Norman Jones€¯ ezt Ć*rta:

Hi Steffi,

See how Ron de Bruin's uses a boolean
variable (ExistFolder) with his ChDirNet
function (based on Rob Bovey's code) to
check for specified folders:

http://www.rondebruin.nl/txtcsv.htm



---
Regards.
Norman


"Stefi" wrote in message
...
Hi All,

I have to check existence of folders. I use DriveExists to check wether
the
specified drive exists and it works if the path starts with a drive letter
(e.g. F:\).
But I have path names starting with a server name (e.g. \\s00dt002\) and I
cannot find a way to check the existence of \\s00dt002\ .

Please help!
Thanks,
Stefi