VBA Excel

[Umbe]

Hi,
I used the MS Communication Control MSCOMM32.OCX for communication
via RS232 in Excel VBA programs.
I download "mscomm32.ocx" and registred it, but I have problems to
insert MSCOMM in form.
Following error message is coming up: "The subject is not trusted for
the specified action".

Any help is appreciated

Regards
Umbe

[shikhar mehta]

I fixed it his way:

Use regedit and then search for:

HKEY_LOCAL_MACHINE\Software\Microsoft\InternetExplorer\
ActiveXCompatibility\{648A5600-2C6E-101B-82B6-000000000014}

If the value of the compatibility flag is 400, Modify the compatibility flag to a value of 0.
it will let you add the control.

> Submitted via EggHeadCafe - Software Developer Portal of Choice
> Review of DevExpress DXperience Control Suite
> http://www.eggheadcafe.com/tutorials/aspnet/f8ce82a9-d5c2-44fc-91af-e67df5ae502f/review-of-devexpress-dxperience-control-suite.aspx

[John Henry]

I found a easier way to fix this problem on a different site. In notepad save this line :

CreateObject("WScript.Shell").RegWrite "HKLM\SOFTWARE\Microsoft\Internet Explorer\ActiveX Compatibility\{648A5600-2C6E-101B-82B6-000000000014}\Compatibility Flags", 0, "REG_DWORD"

use .vbs extention when saving the file. Double click on the file to run the code. This worked for vba in Autocad 2007

> On Wednesday, September 16, 2009 10:23 PM Umbe wrote:

[jbowd...@gmail.com]

On Tuesday, October 19, 2010 8:28:39 AM UTC-7, shikhar mehta wrote:
> I fixed it his way:
>
> Use regedit and then search for:
>
> HKEY_LOCAL_MACHINE\Software\Microsoft\InternetExplorer\
> ActiveXCompatibility\{648A5600-2C6E-101B-82B6-000000000014}
>
> If the value of the compatibility flag is 400, Modify the compatibility flag to a value of 0.
> it will let you add the control.

When I found this post, I tried it but it did not work for me :-(

THEN I REALIZED THAT THERE WERE MULTIPLE INSTANCES of that CLSID
in the Registry! So it might be a better idea to search for the
648A5600-2C6E-101B-82B6-000000000014 and, if it has a Compatibility Flags
field that is 400, change it to 0. THEN USE F3 TO SEARCH AGAIN!
So you change ALL of the occurrences of that killbit.

Be sure to start your Registry search from the top by highlighting the word
Computer in the top of the left-hand pane before you do the Edit/Find.
Otherwise it seems to start searching from wherever you did your last
Registry edit.

This one was the one I needed on Win7/64:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Internet Explorer\ActiveX Compatibility\{648A5600-2C6E-101B-82B6-000000000014}

It kind of makes sense that there is a separate one for x64 purposes but
what a frustration to find it! Good luck!

- Jay