SharedWorkspaceFile.URL Property

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 -. 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:

• SharedWorkspaceFile Object
• SharedWorkspaceFile Object Members