dcsimg
Results 1 to 3 of 3

Thread: MSCOMM error in Excel 2007

  1. #1

    Thread Starter
    New Member
    Join Date
    Jul 2010
    Posts
    11

    MSCOMM error in Excel 2007

    Hi All,

    I m trying to create a VBA application in excel 2007.

    My application requires serial port connection and hence i have downloaded MSCOMM32.ocx and had registered it under c:/windows/system32/MSCOMM32.ocx

    In the Toolbox of VBA using additional controls i selected the Microsoft communication control 6.0. The icon of serial port comm control got added in the toolbox.

    Now when i drag the com port control to my form i get an error "The subject is not trusted for specified action".

    I m not sure how to eliminate this error.

    I m using windows 7 OS. I searched internet for the solution but in vain.

    Any suggestion is much appreciated.

  2. #2
    New Member
    Join Date
    Aug 2010
    Posts
    1

    Re: MSCOMM error in Excel 2007

    Ironic, I was just having the same problem and found this page:

    http://www.tek-tips.com/viewthread.c...1562618&page=1

    Basic issue as reported is that Internet Explorer security settings can block mscomm32.ocx from being used. Solution was to modify a registry setting as follows:

    Here is their solution:

    >>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, there is your problem. Modify the compatibility flag to a value of 0.
    >>If the value is already 0 then your problem is elsewhere.

    Fixed things for me. See that thread for more details and discussion. Your mileage may vary.

  3. #3
    New Member
    Join Date
    Oct 2010
    Posts
    2

    Re: MSCOMM error in Excel 2007

    hey it solved the problem.
    thanks :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width