ahha Posted December 4, 2022 Posted December 4, 2022 I have been using Water's excellent Word UDF for years with a local copy of Microsoft Word on the local machine. My question is regarding Word in Word 365, or Microsoft 365, or Office 365, or whatever Microsoft calls the cloud version now. Can I use the existing UDF with some modification, or is there a UDF for the cloud, or am I completely misunderstanding how the cloud version works? I have not yet purchased the cloud version of Word (or MIcrosoft/Office 365) and so have not yet tried coding for it. Thanks for any assistance. ahha
Marc Posted December 4, 2022 Posted December 4, 2022 "Microsoft 365" (that's the current name as of 2022-12-04, may change ^^) still offers a standard installation of the software on your PC. Seems to work fine Any of my own codes posted on the forum are free for use by others without any restriction of any kind. (WTFPL)
water Posted December 4, 2022 Posted December 4, 2022 All of my UDFs use COM to interact with MS programs. So they only work with local installations. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
ahha Posted December 4, 2022 Author Posted December 4, 2022 Marc - thanks. I think that's the version that does not connect to the cloud. Water - thanks. I was afraid that was the case. Looks like we're going back to the mainframe - terminal model (again Both - Which brings up the question of how one tells if it's the cloud version versus local installation?
water Posted December 4, 2022 Posted December 4, 2022 Maybe this helps: https://answers.microsoft.com/en-us/msoffice/forum/all/how-do-i-find-out-if-i-have-office-365-on-my/2d8e02ad-33c7-4d62-a005-1dfd4fc752a3 My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
ahha Posted December 4, 2022 Author Posted December 4, 2022 Water - thanks. Microsoft instructions, not very helpful. I was hoping for a programmatic way to determine it.
Solution water Posted December 4, 2022 Solution Posted December 4, 2022 You could try to start the local version of MS Word using function _Word_Create. If you get @error=1 one of the reasons could be that there is no local installation of MS Word. Check @extended for the COM error code. My UDFs and Tutorials: Spoiler UDFs: Active Directory (NEW 2024-07-28 - Version 1.6.3.0) - Download - General Help & Support - Example Scripts - Wiki ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts OutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - Wiki OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki PowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - Wiki Task Scheduler (2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs: Excel - Example Scripts - Wiki Word - Wiki Tutorials: ADO - Wiki WebDriver - Wiki
ahha Posted December 4, 2022 Author Posted December 4, 2022 Water - thanks. I'' try that on a blank machine later this week.
pdvos Posted December 5, 2022 Posted December 5, 2022 It's based on subscription. If you have a MS365 Basic it comes with browser only applications for word/excel etc, If you have MS365 Standard it comes with the option to install the classic non-cloud desktop "called premium" applications and they work just like the regular applications. The premium applications are also connected to the cloud for activation and integration with onedrive / sharepoint so it's easy to work with documents in the cloud. So basically you have to determine using the control panel to see if the premium apps are installed search for "Microsoft 365 Apps for business" of whatever it's called in your local language.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now