Solved

Retrieve Full FilePath from saved file using Mapped Drives

Posted on 2007-11-19
2
764 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
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus Notes Mail Database issues 2 953
Event in Notes Form after open and visible 10 222
@ command if structure getting unmanageable 12 100
Add a cc field to email code 6 100
For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

830 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