question

RobJ-8510 avatar image
0 Votes"
RobJ-8510 asked ·

Outlook automation not working with click to run (C2R) installation

I've asked this question on 3 Nov 2020 with no response so posting here.

https://social.msdn.microsoft.com/Forums/en-US/ed026ca6-2415-4eab-be9a-7e4d89723fd5/click-to-run-office-automation-not-working?forum=officegeneral


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.

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

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.

oOutlook=createobject("Outlook.Application")









office-vba-dev
· 2
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @RobJ-8510,

Welcome to our forum.

Please kindly understand we mainly focus on general issues on Outlook desktop client under outlook tag, considering your issue may be more related to development instead of Outlook desktop client, so I removed outlook tag, thanks for your understanding and hope your issue would be resolved soon.

0 Votes 0 ·

Jade,

I appreciate that. I wasn't sure and there was only a couple of outlook options. As no-one answered previous post I thought i'd try both tags,.

Can you point me to a more development orientated forum that could help with this issue?

Thanks
Rob

0 Votes 0 ·

1 Answer

TvanStiphout avatar image
0 Votes"
TvanStiphout answered ·

Since you did not get a great reply yet, I will add a lousy reply. In the sense that it does not solve your problem but perhaps sheds more light on it.

This is not necessarily an issue or CtR or MSI, but it is a correlated issue. The real issue is that a few years ago MSFT decided Office objects should live in their own protected part of the registry, not accessible by a simple CreateObject. So CreateObject fails because that object is not in your normal HKLM or HKCU hive.

Reading the tea leaves MSFT has afterwards realized this broke a lot of apps like yours and is gradually clawing its way back.

As an Access developer I am lucky I can install a "pre-bad_idea" version of the database engine and third party applications are OK. Unfortunately I am not at all sure a similar avenue exists for you as an Outlook developer.

Maybe, just maybe you can use this slimy hack: realizing that all Office apps are living in the same bubble and can happily CreateObject between each other, and realizing what I just said about Access, is it possible to create an interface using Access that in turn automates Outlook? I would give that about an 80% to succeed in the hands of an expert developer.

· 1 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Tvan,

That's not going to help as I need to fully automate outlook directly.
Also, not all PC's will have Access installed as part of their office installation.

However I really appreciate you taking the time to reply.

Rob

0 Votes 0 ·