LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 16
Default How to Connect a network Drive

I know I can do that but the problem is that up to now I have not kept the
absolute path starting with \\server\...

I have just made a list of potential path that could be used but those path
are just kept whith their Network Drive letter, not with their full path...
And then when then Network Drive my users will like to use is not connected I
have no way up to now to provoce the re-connection, not no way to recover the
full path... except if this last one would be available somewhere like in a
Registry key...

The unique solution I can imagine at the moment is to keep a memo of the
full path in // to the logical path at the time it is entered in my list...
Then I will be able to reconnect it using net use or any other possible
function for that task...

Thanks for your input
Alain

PS regarding your code proposal
thanks to remember I cannot access the full path
mine is a follow

set fso = CreateObject("Scripting.FileSystemObject")
set objFolder = GetFolder(Z:\SharedFolder)
Z is here a map drive I created through Explorer

the <<set objFolder code line produces an error if the Network Drive is
not connected which is systematically the case just after login...
If you go to the explorer and click inside the Z drive = it open it
Then the same code lines will not produce any errors...


 
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
Network drive Greg Excel Worksheet Functions 1 January 13th 10 04:22 AM
map network drive lumpy04 Excel Programming 1 June 5th 08 03:49 PM
Using An Add-in On A Network Drive Using An Add-in On A Network Drive Excel Programming 5 June 15th 05 09:21 PM
Link workbooks-C drive to network drive Earl Excel Worksheet Functions 0 April 19th 05 05:50 PM
Userform Local Drive & Network drive question Joel Mills Excel Programming 3 December 29th 04 10:43 PM


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

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

About Us

"It's about Microsoft Excel"