SharedWorkspace members (Office)

The SharedWorkspace property of a Document object in Microsoft Word, a Workbook object in Microsoft Excel, and a Presentation object in Microsoft PowerPoint returns a SharedWorkspace object that allows the developer to add the active document to a SharePoint site and to manage other objects in the shared workspace site.

Methods

Name Description
CreateNew Creates a document workspace site on the server and adds the active document to the new shared workspace site.
Delete Deletes the current shared workspace and all data within it.
Disconnect Disconnects the local copy of the active document from the shared workspace site.
Refresh Refreshes the local cache of the SharedWorkspace object's files, folders, links, members, and tasks from the server.
RemoveDocument Removes the active document from the shared workspace site.

Properties

Name Description
Application Gets an Application object that represents the container application for the SharedWorkspace object (you can use this property with an Automation object to return that object's container application). Read-only.
Connected Gets a Boolean value that indicates whether or not the active document is currently saved in and connected to a shared workspace. Read-only.
Creator Gets a 32-bit integer that indicates the application in which the SharedWorkspace object was created. Read-only.
Files Provides access to the SharedWorkspaceFile objects in the SharedWorkspace. Read-only.
Folders Gets a SharedWorkspaceFolders collection that represents the list of subfolders in the document library associated with the current shared workspace. Read-only.
LastRefreshed Gets the date and time when the Refresh method was most recently called. Read-only.
Links Gets a SharedWorkspaceLinks collection that represents the list of links saved in the current shared workspace. Read-only.
Members Gets a SharedWorkspaceMembers collection that represents the list of members in the current shared workspace. Read-only.
Name Gets or sets the display name of the shared workspace site. Read/write.
Parent Gets the Parent object for the SharedWorkspace object. Read-only.
SourceURL Designates the location of the public copy of a shared document to which changes should be published back after the document has been revised in a separate document workspace site. Read-only.
Tasks Gets a SharedWorkspaceTasks collection that represents the list of tasks in the current shared workspace. Read-only.
URL Gets the top-level Uniform Resource Locator (URL) of the shared workspace. Read-only.

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.