Edit

SharedWorkspaceLink.URL property (Office)

  • Article

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.

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: https://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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.