Treat string as condition in VBA

[DocAElstein]

...settings are for recent versions of Office that use the so-called Click-to-Run technology.....

OK, thx. Hopefully I won't have to worry about these things for a while.
( I have some gut eerie feeling in my bones after just a quick google just now, that the click to run stuff is somehow part of Microsoft keeping control of you and how you do things, and at the same time maybe fitting in better with the zombie world of ask your smart phone what it wants you to do. All part of the world of subscribe to me and do what I say….)

[SpeakEasy]

Get the full lowdown here: https://support.microsoft.com/en-us/top ... 9f9dbb443d

[YasserKhalil]

I have tried the registry fix but I encountered the same error.

[SpeakEasy]

One of these should work to enable vbscript

Code: Select all

Windows Registry Editor Version 5.00

; Classic Office 2010/2013
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

Code: Select all

Windows Registry Editor Version 5.00

; Classic Office 2016 and later
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

Code: Select all

Windows Registry Editor Version 5.00

; Click-to-run Office 2016 and later
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\16.0\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

Code: Select all

Windows Registry Editor Version 5.00

; Click-to-run Office 2010/2013
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Microsoft\Office\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\REGISTRY\MACHINE\Software\Wow6432Node\Microsoft\Office\Common\COM Compatibility\{B54F3741-5B07-11cf-A4B0-00AA004A55E8}]
"ActivationFilterOverride"=dword:00000001

[YasserKhalil]

Amazing. Thank you very much. Now it worked on my side.