With Microsoft 365, you receive additional benefits including Microsoft Editor, Money in Excel, and premium creative content in Office, plus more to come.Microsoft Office Home and Business 2019 provides classic Office apps and email for families and small businesses using one Mac. We’ve added value to the Office 365 subscription to make it Microsoft 365. Microsoft 365 includes everything you love about Office 365 and more, at the same price.
![]() ![]() However, many institutions have implemented two-factor authentication, which makes that impossible. (The search and replace subroutine in the code comes from the Mac OS X Automation site, with thanks.)It’s worth briefly mentioning (so that I don’t get hundreds of comments below) that it’s sometimes possible to setup a webdav connection to Sharepoint so you can access the files via Finder. But surely it’s actually already there…?! However, unless you copy or move the file you aren’t able to share it.Wouldn’t it be better just to be able to open the Sharepoint cloud file within the Office docs, simply by double-clicking it within the OneDrive listing of macOS’ built-in Finder?This is a bit of a hack using AppleScript, so comes without warranty or guarantee. If you click the Share button you’re immediately prompted to “move” or “copy” the file to the Sharepoint cloud to make it available to colleagues. Office 365 For Business How To Create YourIf the file IS within OneDrive then the little app instructs the Office app to open the Sharepoint cloud version instead of the file on your hard disk. If it ISN’T then it’s opened as usual within the Office app, just as it would be normally. It’s means you can actually use Microsoft Office in the cloud, as Microsoft would like you to.And to do this, I’m going to tell you how to create your own DIY handler app to open Sharepoint cloud files.In a split second this little app checks to see if the file you’ve just double-clicked in Finder is in your OneDrive folder. Theme powerpoint 2016 for macThe first is the file path to your OneDrive folder. Then click the OneDrive for Business option, and provide your login details.You’ll need to discover two things before starting. This can be done using the File > Open dialog box, clicking the Online Locations dialog box, and then clicking Add a Place. Then paste within a word processor. In other words, if you view whatever is at the Sharepoint path you’ll see exactly what you see when you view the OneDrive folder on your computer.One way to discover this is to visit the Sharepoint folder in the File Open dialog box of any of the Office apps, then right-click any file and select Share > Copy Path. Just remove the filename from the end.Next, you need to know your personal Sharepoint path that matches the OneDrive folder. You’ll then see the path you need to note. If you work for a company the file path might be something like /Users/username/OneDrive – Corporation PLC/.One trick is to open a Terminal window, and drag and drop a file from the OneDrive folder on top of it. “username” will your your Mac username. ![]() " & newFilename buttons "I'm waiting." giving up after 3Do shell script "open -a 'Microsoft Word' " & quoted form of originalFilenameOn replace_chars(this_text, search_string, replacement_string)Set AppleScript's text item delimiters to the search_stringSet the item_list to every text item of this_textSet AppleScript's text item delimiters to the replacement_stringSet AppleScript's text item delimiters to "" Once you’ve pasted, click the little hammer icon on the toolbar to check the code – if it instantly color-codes without an error then it’s fine:Set originalFilename to POSIX path of theDroppedItemsIf originalFilename contains "OneDrive" thenSet newFilename to replace_chars(originalFilename, "ONEDRIVE-PATH", "SHAREPOINT-PATH")Do shell script "open -a 'Microsoft Word' " & quoted form of newFilenameDisplay dialog "Fetching from Sharepoint and opening. In the Word Sharepoint Handler window, paste in the following code – you can select all of this at once, and just paste it right into Script Editor. When saving each, select “Application” from the File Format dropdown list. Call the first one Word Sharepoint Handler, the second Excel Sharepoint Handler, and the third PowerPoint Sharepoint Handler. Save each of the new files you’ve created in your Documents folder, or another safe location where you know they won’t be deleted. " & newFilename buttons "I'm waiting. In the PowerPoint handler window, paste in the following replacing the OneDrive and SharePoint paths:Do shell script "open -a 'Microsoft PowerPoint' " & quoted form of newFilenameDisplay dialog "Fetching from Sharepoint and opening. Repeat the above step for the Excel handler window, pasting in the following and entering your OneDrive and Sharepoint paths:Do shell script "open -a 'Microsoft Excel' " & quoted form of newFilenameDo shell script "open -a 'Microsoft Excel' " & quoted form of originalFilename Don’t delete any quote marks from the code! Something like /Users/johnsmith/OneDrive/), and replace SHAREPOINT- PATH with the Sharepoint path you discovered (e.g.
0 Comments
Leave a Reply. |
AuthorTaylor ArchivesCategories |