View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Test to see if a server is mapped

http://support.microsoft.com/default...;en-us;Q291573
HOWTO: Use Visual Basic to List Active Logical Drives

http://support.microsoft.com/default...;en-us;Q189667
HOWTO: List the Drives in a System Using the FileSystemObject


http://support.microsoft.com/default...;en-us;Q256847
Q256847 - HOWTO: Use the WNetUseConnection API to Map a Drive in Visual
Basic

http://support.microsoft.com/default...;en-us;Q192689
Q192689 - HOWTO: Get UNC Path From a Mapped Network Share's Drive Letter

should get you started. I would assume a username and password would have
to be supplied in your second instance.

--
Regards,
Tom Ogilvy

"Tempy" wrote in message
...
Good day, as a newbie i am not sure if this is possible ?
I run some code that asks the user to put in the file name and save it
but i need to first test and see if he is mapped to the server.
Secondly is it possible to map to a drive with a user name and password
and then save the file ?

Tempy

*** Sent via Developersdex http://www.developersdex.com ***