View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Alain-79 Alain-79 is offline
external usenet poster
 
Posts: 16
Default How to Connect a network Drive

Hi Joel, my code works in many circumstances... and even the part with which
I am facing problems do not produce any errors as soon as the Network drive
is "Connected"

My current problem would rather be to be said as follow

1 - I have saved somewhere a path based on a Network Drive - let say Z:\Folder
2 - I have not savec the full path starting with \\server\...\Folder

3 - After a while or after a logoff - logon, the Network Drive is not
connected any more - you can see that in the explorer when looking to "My
Computer"... all Network drive present either the status "Disconnected
Network Drive" or "Network Drive" only for all connected ones...
4 - if at that moment I run those code lines I get an error
- set fso = CreatObject("Scripting.FileSystemObject")
- Set folder = fso.GetFolder(Z:\Folder)

I know that I could have it working if I could access the full path but do
not know how to recover it on a Disconnected Network Drive ? in a registry
key ?

Thanks for your help
Alain