Treat string as condition in VBA

User avatar
DocAElstein
4StarLounger
Posts: 546
Joined: 18 Jan 2022, 15:59
Location: Re-routing rivers, in Hof, Beautiful Bavaria

Re: Treat string as condition in VBA

Post by DocAElstein »

HansV wrote:
23 May 2023, 10:29
...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….)
I seriously don’t ever try to annoy. Maybe I am just the kid that missed being told about the King’s new magic suit, :(

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: Treat string as condition in VBA

Post by SpeakEasy »


YasserKhalil
PlatinumLounger
Posts: 4911
Joined: 31 Aug 2016, 09:02

Re: Treat string as condition in VBA

Post by YasserKhalil »

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

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: Treat string as condition in VBA

Post by 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
PlatinumLounger
Posts: 4911
Joined: 31 Aug 2016, 09:02

Re: Treat string as condition in VBA

Post by YasserKhalil »

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