Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,646
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 421
Default 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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Remove end folder from path found with ThisWorkbook.Path command ? dim Excel Programming 9 April 23rd 08 06:04 AM
Spell Checking with checking cell notes jfitzpat Excel Discussion (Misc queries) 0 August 8th 07 10:26 PM
Checking range of cells for entry then checking for total Barb Reinhardt Excel Programming 1 October 13th 06 02:47 PM
hyperlink navigation path path wrong in Excel 2003 CE Admin Excel Discussion (Misc queries) 5 January 7th 06 07:47 PM
Checking if workbook open (where path is unknown) [email protected] Excel Programming 0 September 4th 03 11:13 PM


All times are GMT +1. The time now is 07:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"