|Post Reply Login
Vba Save To Skydrive
Rate this:(4/5 from 2 votes)
|In Excel 2010 we can share a workbook directly as a web application on SkyDrive. This supports a wide range of functionality including standard pivot tables, charts and slicers. The published workbook does not support certain features such as links to external sources or VBA macros. Therefore to save the current workbook to SkyDrive using VBA, we can make a copy and remove the unsupported features. By specifying some SkyDrive information, we can then automate the publishing process directly from the macro enabled workbook.
An example of the information required is like:
Where SkyDrive ID is the account number that can be found in the URL when logged in through Windows Live, and SkyDrive folder is the folder in SkyDrive to publish to.
The VBA code required with detailed comments is:
Sharing and permissions can then be made directly on SkyDrive.
|Excel Business Forums Administrator
|Posted by Excel Helper on
|Replies - Displaying 1 to 1 of 1
|Order Replies By: Most Recent | Chronological | Highest Rated
Hi, this looks really usefull and I'm looking at doing somthing similar. I was just wondering if you could by any chance update this method to work with OneDrive (as it is now called), I can't figure out with DOM explorer where you got the address from. If you also knew a way to open files directly from OneDrive that would be greatly appreciated.
Rate this:(3/5 from 1 vote)
|Posted by Skimber on
|Displaying page 1 of 1
|Find relevant Excel templates and add-ins for VBA Save to SkyDrive in the Excel Business Solutions Directory