none
Click to Run office automation not working RRS feed

  • Question

  • Hi,


    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:-


    1, Open Excel

    2, Open a blank workbook

    3, Click View then Macros

    4, type test and click "Create"

    5, Click Tools then References

    6, Click Browse 

    7, Select either 

      •   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.

     

    8, 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

    https://answers.microsoft.com/en-us/msoffice/forum/msoffice_install-mso_win10-mso_2016/office-click-ro-run-and-ole-automation/abc2fe0d-58e4-42eb-84ef-a6e7c1c7b3f4

    • Edited by rob-j Wednesday, November 4, 2020 1:39 PM Added link to another post with an alternate work around.
    Tuesday, November 3, 2020 12:34 PM