Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Remove end folder from path found with ThisWorkbook.Path command ? | Excel Programming | |||
Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
Checking range of cells for entry then checking for total | Excel Programming | |||
hyperlink navigation path path wrong in Excel 2003 | Excel Discussion (Misc queries) | |||
Checking if workbook open (where path is unknown) | Excel Programming |