Share a Workbook
Anything you can do through the task pane, you can also do in codeâactually, you can do more.
Use the Workbook objectâs SharedWorkspace
property to work with shared workspaces in Excel. The SharedWorkspace
property returns a SharedWorkspace object that you use to share the workbook, update the workbook, and navigate among other elements in the shared workspace.
How to do it
Use the SharedWorkspace objectâs CreateNew
method to create a new shared workspace and add a workbook to it:
ThisWorkbook.Save ThisWorkbook.SharedWorkspace.CreateNew _ "http://excelnotebook.sharepointsite.com", "ch02"
You must save the workbook before adding it to a shared workspace, otherwise the CreateNew
method fails. The preceding code adds the current workbook to the SharePoint site on the excelnotebook.sharepointsite.com server. If you click on Open site in browser in the Excel Shared Workspace pane, Excel displays the new workspace created at
http://excelnotebook.sharepointsite.com/ch02
(Figure 2-7).
Note
You can do a lot with shared workspaces through the SharePoint site and the Excel task pane, but by understanding the object model you can customize sharing (almost) any way you like.
If you call CreateNew again, Excel will create another, new workspace and increment the site name to http://excelnotebook.sharepointsite.com/ch02(1) . Remember, Excel creates one workspace folder per document.
In some cases, you may want to add other documents to an existing workspace. ...
Get Excel 2003 Programming: A Developer's Notebook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.