Gets the top-level Uniform Resource Locator (URL) of the shared workspace link. Read/write.
Note Beginning with Microsoft Office 2010, this object or member has been deprecated and should not be used.
expression. URL
expression A variable that represents a SharedWorkspaceLink object.
String
The URL property returns the address of the shared workspace in this format: http://server/sites/user/workspace/. The URL property returns a URL-encoded string. For example, a space in the folder name is represented by %20. Use a simple function like the following example to replace this escaped character with a space. Private Function URLDecode(URLtoDecode As String) As String URLDecode = Replace(URLtoDecode, "%20", " ") End Function
The following example displays the URL of the link to the shared workspace.
MsgBox "URL: " & ActiveWorkbook.SharedWorkspaceLink.URL, _
vbInformation + vbOKOnly, "Shared Workspace Link URL"