SharedWorkspaceLink.URL Property

Syntax

expression.URL

expression A variable that represents a SharedWorkspaceLink object.

Return Value
String

Remarks

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 -. 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, "-", " ") End Function

Example
The following example displays the URL of the link to the shared workspace.

MsgBox "URL: " & ActiveWorkbook.SharedWorkspaceLink.URL, _ vbInformation + vbOKOnly, "Shared Workspace Link URL"

See also:

• SharedWorkspaceLink Object
• SharedWorkspaceLink Object Members