ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   checking path (https://www.excelbanter.com/excel-programming/411890-checking-path.html)

Stefi

checking path
 
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


Norman Jones[_2_]

checking path
 
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



Stefi

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




All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com