I've asked this question on 3 Nov 2020 with no response so posting here.
For years I have been automating office from 3rd party software but Microsoft 365 Click To Run versions do not register themselves on windows to allow office to be automated from 3rd party software.
However the "Click to Run" versions of "Office 365" or now "Microsoft 365" are pretty much all that seems to get installed these days.
How do we activate the "CLICK TO RUN" versions of Office so we can use office automation from 3rd party software without having to do the following:-
Open a blank workbook
Click View then Macros
type test and click "Create"
Click Tools then References
c:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\mso.dll
c:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX86\Microsoft Shared\OFFICE16\mso.dll
Depending if you have 64 bit office or 32 bit office.
Click OK and close the Microsoft Visual basic for Application then close Excel.
Another poster had same problem and registered typelib regtlib.exe but regtlib.exe is not on the PC. See
Can anyone please let me know how we can get Outlook to respond to the below command if the retail version of Microsoft Office or Outlook is not installed but is installed with a Click-to-run installation.