Table of contents
TOC
Collapse the table of content
Expand the table of content

SharedWorkspaceFile.URL Property (Office)

office 365 dev account|Last Updated: 6/12/2017
|
1 Contributor

Gets the full Uniform Resource Locator (URL) and file name of the shared workspace file. Read-only.

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 SharedWorkspaceFile object.

Return Value

String

Remarks

The URL property returns the address of the shared workspace file in this format: http://server/sites/user/workspace/Shared%Documents/MyWorkbook.xls. The URL property returns a URL-encoded string. For example, a space in the folder name is represented by %20. The SharedWorkspaceFile object does not have a Name or FileName property. The filename must be extracted from the URL property.

Example

The following example displays the URL of the shared workspace file.

MsgBox "URL: " & ActiveWorkbook.SharedWorkspaceFile.URL, _ 
        vbInformation + vbOKOnly, "Shared Workspace File URL"

See also

Concepts

SharedWorkspaceFile Object

Other resources

SharedWorkspaceFile Object Members

© 2018 Microsoft