View Single Post
  #1   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

Using fso, I need to be able to make a getFolder on several possible path
including Network Drives... but when one of them is not connected I get an
error...

It's rather simple to open the explorer and to click on this network drive
in order toget it connected... but how can I automate this through vba code...

In other words: How can I through vba connect an existing network drive and
this even if I have just the logical path such as Z:\Folder

Using <<Net Use would imply I have kept the network path such as
\\server\...\shared folder or at least that I am capable of recovering it...

Thanks for any potential help...
Regards
Alain