Article ID: 160529 - View products that this article applies to.
This article was previously published under Q160529
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article describes how to use a Microsoft Visual Basic for Applications sub-procedure (or macro) and a Windows application programming interface (API) call to return the universal naming convention (UNC) path for a mapped network drive.
Microsoft provides programming examples for illustration only, without warranty either expressed or implied, including, but not limited to, the implied warranties of merchantability and/or fitness for a particular purpose. This article assumes that you are familiar with the programming language being demonstrated and the tools used to create and debug procedures. Microsoft support professionals can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific needs.
If you have limited programming experience, you may want to contact a Microsoft Certified Partner or Microsoft Advisory Services. For more information, visit these Microsoft Web sites:
Microsoft Certified Partners - https://partner.microsoft.com/global/30000104
Microsoft Advisory Services - http://support.microsoft.com/gp/advisoryservice
For more information about the support options that are available and about how to contact Microsoft, visit the following Microsoft Web site:http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS
(http://support.microsoft.com/default.aspx?scid=fh;en-us;cntactms)A UNC is a naming convention that permits you to use a network resource, such as a network server, without formally connecting to the network resource with a mapped drive. A UNC path uses the following syntax:
\\<Server>\<Share>where <Server> is the name of the network server and <share> is a folder on the server.
A mapped drive uses a drive letter (for example, drive F:), where the letter represents the server and the share to which it is mapped.
The following code samples use a Windows API call to locate the mapped drive and then return its UNC path.
Microsoft Office 97 and Microsoft Office 7.0
Microsoft Excel 5.0
For additional information about getting help with Visual Basic forApplications, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/163435/EN-US/ )VBA: Programming Resources for Visual Basic for Applications
Article ID: 160529 - Last Review: January 19, 2007 - Revision: 4.5