ahha Posted December 4, 2022 Share 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 Link to comment Share on other sites More sharing options...
Marc Posted December 4, 2022 Share 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) Link to comment Share on other sites More sharing options...
water Posted December 4, 2022 Share 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 Link to comment Share on other sites More sharing options...
ahha Posted December 4, 2022 Author Share 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? Link to comment Share on other sites More sharing options...
water Posted December 4, 2022 Share 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 Link to comment Share on other sites More sharing options...
ahha Posted December 4, 2022 Author Share Posted December 4, 2022 Water - thanks. Microsoft instructions, not very helpful. I was hoping for a programmatic way to determine it. Link to comment Share on other sites More sharing options...
Solution water Posted December 4, 2022 Solution Share 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 Link to comment Share on other sites More sharing options...
ahha Posted December 4, 2022 Author Share Posted December 4, 2022 Water - thanks. I'' try that on a blank machine later this week. Link to comment Share on other sites More sharing options...
pdvos Posted December 5, 2022 Share 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. Link to comment Share on other sites More sharing options...
Kavynglepner Posted October 16, 2023 Share Posted October 16, 2023 (edited) I've had a similar question before. While the existing Word UDF might work to some extent, there could be limitations with the cloud version due to differences in how it operates. It might be worth trying with a trial version to see how well it adapts or exploring if there are specific UDFs for the cloud version. You can take a course to be a security operations analyst associate; that'll help you navigate it. Good luck! Edited October 20, 2023 by Kavynglepner Link to comment Share on other sites More sharing options...
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