+ Reply to Thread
Results 1 to 7 of 7

Serial Port Communications within Excel

  1. #1
    Registered User
    Join Date
    03-29-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Serial Port Communications within Excel

    Hello. I'm looking for a way to communicate through the serial port while in Excel. I used to use Excel 2003, and had MSComm objects setup to work within my code. With these objects, I was able to trap on incomming comm events and parse any new data that was coming from the serial port.

    However, when I moved over to Excl 2007, the MSComm object seems to have gone away, and I can't find any replacement object. Does anybody know how to do this kind of thing?

    Thanks in advance.

  2. #2
    Registered User
    Join Date
    02-21-2010
    Location
    Italy
    MS-Off Ver
    Excel 2013
    Posts
    77

    Re: Serial Port Communications within Excel

    Hi,
    you may want to give a look at this:-)

    bye
    P.

  3. #3
    Registered User
    Join Date
    03-29-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Serial Port Communications within Excel

    Quote Originally Posted by fredpox View Post
    Hi,
    you may want to give a look at this:-)
    Thanks for the link, however I'm still getting an error when trying to insert the MSComm object. ("Cannont insert object"). I'm wondering if this is because I'm using Windows 7, and the MSCOMM.OCX file isn't installing correctly as explained in your linked post?

    When I run the register32 to install the OCX in Command prompt ... it says it installed successfully. However when I attempt to insert the object into an Excel sheet, I get the cannot insert error.
    Last edited by ExclDawg; 03-29-2010 at 03:52 PM.

  4. #4
    Registered User
    Join Date
    02-21-2010
    Location
    Italy
    MS-Off Ver
    Excel 2013
    Posts
    77

    Re: Serial Port Communications within Excel

    Hi,
    I don't know if this makes any sense in your case, since you already registered the OCX but I'd try to unregister and register again the .OCX file.

    Run cmd and type the following to unregister the OCX
    C:\WINDOWS\SYSTEM\REGSVR32.EXE /u C:\WINDOWS\SYSTEM\MSCOMM32.OCX
    and then after the message pops up type this to register again the OCX
    C:\WINDOWS\SYSTEM\REGSVR32.EXE C:\WINDOWS\SYSTEM\MSCOMM32.OCX

    Unluckily I'm by far not an expert on this and I'd wait for other gurus help.

    bye
    P.

  5. #5
    Registered User
    Join Date
    03-29-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Serial Port Communications within Excel

    Still no luck. I'm thinking it might have to do with the registries.

    I did what was suggested, and added in this reg entry:
    HKEY_CLASSES_ROOT\Licenses\4250E830-6AC2-11cf-8ADB-00AA00C00905

    And set the (Default) to: kjljvjjjoquqmjjjvpqqkqmqykypoqjquoun

    Is there another registry I need for it to work? Do I also need to have Visual .NET installed on the system for this to work? (I was hoping I could run this outside of a Dev environment as well).

    Thanks!

  6. #6
    Registered User
    Join Date
    09-05-2010
    Location
    Argentina, Bs.As.
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Serial Port Communications within Excel

    Hi ExclDawg.
    If your W7 is 64 bit try to paste the MSCOMM32.OCX in the folder "SysWOW64" no in "System32" and register in this folder. Remmember unregister and quit the OCX of System32.

  7. #7
    Registered User
    Join Date
    10-16-2013
    Location
    Paarl, South Africa
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: Serial Port Communications within Excel

    I know this is an old post but this may be of use to someone, could not get mscomm32 to work and eventually stumbled on to an ocx file called NETComm, this is a free download and must be registered under the system32 directory in win 7 64bit.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1