View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming
KevinGPO
 
Posts: n/a
Default Dir() time-out woes :( .....

What is the best way to test whether a drive exists? Sometimes the Dir("C:")
returns "" even when the drive is completely valid.

Maybe I should do ChDrive then test Err.Number. Then ChDir then test
Err.Number???


"KevinGPO" wrote in message
...
When I call the function Dir("Q:\") and Q:\ is a network mapped drive does
it fail (return "") if it does not receive a reply within a certain
time-limit? The reason why I ask is because the update response from a
network mapped drive is very slow here. If the slow response causes
Dir("Q:\") function to return "" then how can I make it longer time-out?