Solved

Retrieve Full FilePath from saved file using Mapped Drives

Posted on 2007-11-19
2
766 Views
Last Modified: 2013-12-18
I have lotusscript that is detaching OLE objects to end user selected file location.  If the user uses a mapped drive I want my script to determine the actual file location on the server.  
ie.
if "Z:\filename.xxx is returned, I need to know server and filepath.
ie.
\\server\filpath\filename.xxx
0
Comment
Question by:Robert Treadwell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 63

Expert Comment

by:SysExpert
ID: 20317077
You will need to capture the list of all the mapped drives possibly by using the net command  to show and output to a text file that you can read, or with WIn32 API , and then substitute as needed.

net use > list01.txt

should show the connected, mapped drives.
You will need to parse it and then substitute as needed.


I hope this helps !

0
 
LVL 31

Accepted Solution

by:
qwaletee earned 250 total points
ID: 20322980

Function ConvertToUNC(Byval letterPath As String) As String
	If Left$(letterPath,2) = "\\" Then 'already a full UNC
		ConvertToUNC = letterPath
		Exit Function
	Elseif Left$(letterPath,1) = "\" Then 'path off current drive
		letterPath = Curdrive$ & letterPath
	REM two possibilities left, either it is a DOS path (x:\folder) or just a folder (NOTES\DATA) that needs current directory in front
	Elseif Mid$(letterPath,2,1) <> ":" Then
		letterPath = Curdir$ & "\" & letterPath
	End If
	
	Dim drive As String, tree As String, network As Variant, drives As Variant, index As Integer, limit As Integer
	drive = Ucase(Left$(letterPath,2))
	tree = Mid$(letterPath,3)
	Set network = CreateObject("WScript.Network")
	Set drives = network.EnumNetworkDrives()
	limit = drives.Count()-1 '0 index, so count is one above the Ubound
	For index = 0 To limit Step 2
		If Ucase(drives(index)) = drive Then
			ConvertToUNC = drives(index+1) & tree
			Exit Function
		End If
	Next index
	ConvertToUnc = drive & tree
End Function

Open in new window

0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

622 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question