Dec 24 2018 08:00 AM
My client is having difficulties adjusting to Office Online. We sync his SharePoint Online library using OneDrive for Business, so he has it easier to upload files they create outside of Office 365. However, they complain that it's too complicated to open any Office files (Word Online, Excel Online, etc.) and I agree.
Is it possible to set his computer up so that double-clicking on xlsx files in his OneDrive folder just opens the file in Word and Excel Online?
Dec 26 2018 07:44 AM
Jul 31 2019 07:24 AM - edited Aug 14 2019 10:19 AM
I believe my situation is similar.
Our company has transitioned from desktop applications to Office 365 (including Excel online). My coworker is struggling to open .xlsx files from her desktop. She knows how to upload and convert them, but I'd like to give her a "connection" or something that will enable her to simply double-click the "files" on her desktop and have them open in Excel Online (or Word Online). I expect the solution will be an extension or add-in or something for Internet Explorer, Firefox, or Chrome, and then the file type can be "associated" with the browser, which would pass it to the extension or add-in.
Yes, the files are in OneDrive, because the Desktop folder is in OneDrive.
Another thought is to simply do it in a batch: upload and convert all the files. Then the question becomes how to get links to all the converted online documents on the desktop (my coworker wants the files "on the desktop").
Any thoughts?
Aug 14 2019 09:00 AM
I'm surprised that there isn't many replies to this post, as many businesses are moving to O365 and looking to save costs by only applying E1 or F1 licenses. We have a workforce of differing skillsets and they just want to be able to open a document in a simple manner at the end of the day.
Aug 14 2019 09:16 AM
Dec 20 2020 01:02 PM
Apr 23 2021 07:42 AM
Mar 06 2022 07:39 AM
May 11 2022 10:16 PM
Aug 16 2022 10:38 AM
Feb 08 2023 06:02 AM
Apr 14 2023 06:27 AM
Aug 11 2023 08:58 PM
I have a solution I rolled in Chatgpt. It would probably take someone that is familiar with C# and Visual Studio to run. Maybe you can find one of your employees and get them to run it. I was going to try to charge you guys but it only took me a couple of minutes. Cheers and I hope this helps.
using Microsoft.Win32;
using System;
using System.Diagnostics;
using Microsoft.Win32;
class Program
{
static void Main(string[] args)
{
RegisterFileAssociation(".docx", "WordOnlineRegEditor", "Open .docx files with YourAppName");
}
static void RegisterFileAssociation(string extension, string appName, string description)
{
using (RegistryKey key = Registry.ClassesRoot.CreateSubKey(extension))
{
key.SetValue("", appName);
}
using (RegistryKey key = Registry.ClassesRoot.CreateSubKey(appName))
{
key.SetValue("", description);
using (RegistryKey commandKey = key.CreateSubKey("shell\\open\\command"))
{
commandKey.SetValue("", "C:\WordOnlineRegEditor.exe \"%1\"");
}
}
}
static void Main(string[] args)
{
if (args.Length > 0)
{
OpenInWordOnline(args[0]);
}
}
static void OpenInWordOnline(string filePath)
{
string wordOnlineUrl = "https://word.office365.com/";
string fileUrl = Uri.EscapeDataString(filePath);
string fullUrl = $"{wordOnlineUrl}/?wopisrc=OneDrive&wdFirstNav=1&wdAllowInteractivity=False&FileUrl={fileUrl}";
Process.Start(fullUrl);
}
}